SQL Server 2005 Doesn't Allocate Available Memory
running Sql Server 2005 SP2 on Windows 2003 Server SP1 with 2GB RAM. After start-up, the sqlservr.exe does only take up around 100 MB of RAM, and it stays roughly there even if the DB is used heavily. This leads to very poor performance, even timeouts on simple querys.
In the task manager, I see that of the 2 GB of RAM, more than 1 GB is still available. I don't understand why SQL Server won't take it?
As a test, I configured the min and max amount of RAM SQL Server should used both to 1024 MB and restarted the service - but it is still the same picture. It won't take more than around 100 MB.
The server has just been restarted, but the problem remains.
BTW there is also an instance of SQL 2000 on the same machine. It shows the same behaviour - I even checked the "reserve phyiscal memory" checkbox there, but it stays on a very low number (50 MB) and doesn't adhere to the supposed size.
thanks and best regards,
- Urs
View Complete Forum Thread with Replies
Related Forum Messages:
Tempdb:Could Not Allocate Allocate A New Object Descriptor Required System Catalog In Database '
A stored procedure executes and create a temp table...during the execution of the stored procedure the application begins returning errors stating : "Select error: Could not allocate a new object descriptor for required system catalog in database '2'. Another database must be closed or objects in another database dropped in order to open this database." I have increased the size of tempdb from 75mb to over 1.5 gigabytes and I am still receiving the error. I have also truncated the log and executed the procedure with tempdb set to truncate log on checkpoint yet the error still occurs. (This is SQL 6.5 running on NT 4.0) Anyone run into this before ? Any suggestions ?
View Replies !
&"Unable To Allocate Sufficient Memory&"
Any help would be appreciated. This message is received on the client. Client pc has Intel 2Ghz or better processor, 512MB Ram, sufficient hard drive space, connecting to MS SQLServer 2000 thru TCP/IP. Database server is running Windows 2000 Advanced Server w/ SP3 and MS SQLServer 2000 Enterprise Edition w/ SP3, with 4 way 700Mhz PIII Xeon processors and 4GB Ram (I'm not certain about network connectivity, but it's at least 100MB Ethernet). The database is approximately 87GB, with an average of 250 to 300 connections. The application is vendor supplied, written in Visual Basic 3.0. Therefore I am using 16 bit SQL drivers, the latest I am aware of, dated 6/15/1997. This database was previously running on SQLServer 7, and this error did not occur. It started after the upgrade to SQLServer 2000. We discovered this error in testing the upgrade and found that by decreasing the "Network Packet Size" setting on SQLServer w/ sp_configure, we were able to make the message go away. However now that we are in a production environment, the message seems to be coming back randomly. We have the NPS set to 1024 (default is 4096). I'm worried about performance if it is dropped much farther. Any ideas? Thanks again for any help!
View Replies !
Why The Memory Usage Of SqlServer Doesn't Go Down
Hi Gurus,Our system is using SqlServer 2005 on XP.( On my machine,only thisapplication access SQLServer.) The sqlserver memory is configured to128MB (Min)~512 MB(Max)After our system get started, sqlserver takes about 100M memory. Afterthe system runs for a while, the memory used by sqlserver goes up to512MB. Then we exit our application and expect the memory usage ofSqlServer could be dropped down to the min value. Unfortunately, itseems SqlServer never release any memory until we restart it.I thought dynamic memory configuration means that SQLServer can autoshrink memory usage if there is no more database accessing. But basedon my observation, SQLserver just holds all the memory . :( How canwe let the sqlServer shrink the memory usage accordingly to workload?I do appreciate for your help!Best regards,Jennifer
View Replies !
VS 2005 Doesn't Work With SQL Server 2005.
When I try to add a SQL Server Database as a new item into the App_Data folder of my Web Project, I get this error demanding that SQL Server Express has to be installed. That is the stupidest thing I have ever heard of. Is there some setting or something to make VS 2005 Pro work with a standard SS database? I don't want to use the express edition. I can't use SS's management studio with that. Does Microsoft monitor this forum? I thought they were going to be taking technology forward; not backwards. I'm losing a lot of time having to install and uninstall and reinstall to get the environment into a mode that works lke I want it to work. If they didn't intend for SS standard edition to be used with VS 2005 Pro, then why did they include SS developers edition in the Pro package?
View Replies !
SQL Server 2005 Cumulative Hot Fix Doesn't Install On X86
I'm trying to install the cumulative hot fix (build 2153) on an x86 machine. I'm running the first of the six install EXEs, and I'm not able to select any of the checkboxes on the Feature Selection tab of the wizard. I see three checkboxes. The first is SQL Server Database Services 2005 and beneath it two child nodes: MSSQLSERVER (RTM 1399 ENU) and SQLEXPRESS (RTM 1399 ENU) None of the checkboxes allow me to select them and when I click the Next button on the screen I get the following: "You have not selected any active products or instances. You must select at least one active product or instance to patch in order to proceed."
View Replies !
SQL Server 2005 Query Logging Doesn't Work
I have been following 3 tutorials to activate and use SQL Server 2005 Query Logging feature in the Analysis Server but none seem to work. I first tested that the connection string worked and it did work. I set the flag to create the table to TRUE and it does not create the table. I tried using filebased logging and no file gets created. I made certain i use QueryLogginFrequency of 1/1 so it logs everything. I second thought was that maybe only .NET applications got logged, but i checked out my current app i'm developping and nothing gets logged. I'm a bit clueless, can anyone point me to something i may have missed that is not obvious in the first few tutorials you find on google...? PS: I did restart my services (MSSQLSERVER and Analysis Server)
View Replies !
Maintenance Plan For SQL Server 2005 64-bit Doesn't Work!
Hi all, We have a SQL Server 2005 64-bit, and recently I upgrade from build 3042 to 3054 and I try to do a maintenance plan for transaction logs(TL) backup, including cleanup for two days (have full backup every night). Problem I have is that I want the TL files to dump in a different location(due to disk space), so I put in the UNC path in the "Create a backup file for every database - >Folder:\FileServerTLDBLogs" NB: if using the local drives, it work Check List Security: - The account that I used to create the plan is an sa account - The location that I dump the TL files, I have full access to the folder SQL Statement: exec xp_cmdshell 'dir FileServerTLDBLogs' (it list all files) Is this a bug for 64-bit? because I can do this on SQL Server 2005 32-bit and it's work perfectly
View Replies !
SQL Server 2005 Express Doesn't Work With .NET Framework 3.0
Hi, Can anybody help me with the following problem: I have Vista Ultimate installed and within Vista .NET Framework 3.0 is installed as a part of the operating system so I can't remove 3.0 Now for MS SQL Server 2005 Express I need .NET Framework 2.0 and the SQL Server 2005 doesn't work with .NET Framework 3.0 Can't install 2.0, get the message that 3.0 is already installed. Is there another version of SQL Server that works with .NET Framework 3.0 and runs under Vista Ultimate? Please help me!! René
View Replies !
Memory In Sql Server 2005
Hi I would like to know how much of memory is taken by sql server 2005 entprise edition 64 bit during sql server startup in default configuration.....(4GB RAM being used). i also want to know about montioring the performance of sql server 2005.Should i continue to use performance monitor (perfmon) or is there any new feature in slq server 2005 which provides performance monitoring. Thanks in advance
View Replies !
Can't Get SQL Server 2005 To Use More Memory
Here'a a break down of what I've done so far. * Windows 2003 32bit Enterprise with 10gb RAM * SQL 2005 32bit Enterprise * boot.ini - have added /3GB /PAE switches * Confirmed which account SQL Server is running under and added that account to Local Policies/User Rights Assignment/Lock pages in memory * Enabled AWE in SQL SERVER * set minimum and maximum server memory to 9gb * Rebooted. Task manager says the following: sqlservr.exe - 95MB usage * I know this is normal when using AWE right? The actual physical memory used is 3.13GB and never goes higher. So this leads to believe that SQL is utilizing 3GB because of the /3GB switch, but it's not using the rest like it should be. I tried it without the /3GB switch and it only went up to about 2.1GB usage. I've turned on performance monitor and SQL server target memory says 8.65 GB while the Total Server Memory says 2.45GB. I've run: EXEC sp_configure 'show advanced options' RECONFIGURE GO EXEC sp_configure 'awe enabled' RECONFIGURE GO And it confirms that the running value for both is 1 Please help.
View Replies !
Caching And Sql Server 2005 Notification (no Polling) Doesn't Refresh The Datagrid!
Hi, I need an help because what I want to do doesn't work and I don't have any error message to understand what it's wrong!I have a DataGridView and I want that it refresh everytime something in the Table (SQL server 2005) happens so is SQL Server Service Broker that pull the data into my web application!!I followd these steps: 1) Enable service broker for that DB2) Global asax (application start): SqlDependency.Start(ConfigurationManager.ConnectionStrings("TestConn").ConnectionString)3) on the page_Load Dim contracts As DataTable = CType(Cache.Get("Contracts"), DataTable)If contracts Is Nothing Then Dim connection As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("TestConn").ConnectionString) Using (connection) Dim command As SqlCommand = New SqlCommand("SELECT field1, field2 FROM dbo.tblContracts", connection) Dim dependency As System.Web.Caching.SqlCacheDependency = New System.Web.Caching.SqlCacheDependency(command) Dim adapter As SqlDataAdapter = New SqlDataAdapter() adapter.SelectCommand = command Dim dataset As DataSet = New DataSet() adapter.Fill(dataset) contracts = dataset.Tables(0) Cache.Insert("Contracts", contracts, dependency) End If GridView1.DataSource = contracts.DefaultView GridView1.DataBind() end Function.I run the application checking the Event viewer, the SQL Profiler and I run the queries:select * from sys.dm_qn_subscriptions select * from sys.transmission_queue when I open the page the first time I see that the Notification services is created under the service broker,select * from sys.dm_qn_subscriptions returns 1 record and once in a while I see in the SQL Profiler: BEGIN CONVERSATION ...WAIT FOR etc...etc...NTUSERNAME:ASPNETNow if I add a new row in the table from SQL Server Managment Studio nothing happens on the Web Page and I can't see neither any error!!What I notice is... once in a while, there is a flippering on the mouse pointer,,, I think that I'm close to reach what I want but I don't understand what is missing ,,Thank you very much for any help!
View Replies !
Memory Configurations For SQL Server 2005 EE X64 With SQL Server 2000 EE X32 On Windows Server EE X64 Server
My server is a dual AMD x64 2.19 GHz with 8 GB RAM running under Windows Server 2003 Enterprise Edition with service pack 1 installed. We have SQL 2000 32-bit Enterprise installed in the default instance. AWE is enabled using Dynamically configured SQL Server memory with 6215 MB minimum memory and 6656 maximum memory settings. I have now installed, side-by-side, SQL Server 2005 Enterprise Edition in a separate named instance. Everything is running fine but I believe SQL Server2005 could run faster and need to ensure I am giving it plenty of resources. I realize AWE is not needed with SQL Server 2005 and I have seen suggestions to grant the SQL Server account the 'lock pages in memory' rights. This box only runs the SQL 2000 and SQL 2005 server databases and I would like to ensure, if possible, that each is splitting the available memory equally, at least until we can retire SQL Server 2000 next year. Any suggestions?
View Replies !
SQL Server 2005 Memory Management
Hi all, I needed to load some tables in memory on startup because of performance reasons. I'm using "select * from <table>", but there are few questions: 1. How to pin already selected data in memory ? (DBCC PINTABLE doesn't work for 2005) 2. How to put index data in memory ? (do you read document(s) for advance memory management - index data caching ?) 3. How to pin index data in memory ? (otherwise sound very bad - table data in fast memory, index data - in slow disks) Thanks in advance: Siol En
View Replies !
SQL Server 2005 Memory Management
Hi all, I needed to load some tables in memory on startup because of performance reasons. I'm using "select * from <table>", but there are few questions: 1. How to pin already selected data in memory ? (DBCC PINTABLE doesn't work for 2005) 2. How to put index data in memory ? (do you read document(s) for advance memory management - index data caching ?) 3. How to pin index data in memory ? (otherwise sound very bad - table data in fast memory, index data - in slow disks) Thanks in advance: Siol En
View Replies !
SQL Server 2005 Std Hogging Way Too Much Memory
Hi: I'm running Windows Small Business Server 2003 Premium R2. I installed SQL Server 2005 Standard Edition on this PC. I'm using Std Edition instead of the Workgroup Edition that comes with SBS since I like the additional features in the Std Edition. I'm a kind of a newbie to Windows Server administration and SQL Server administration although I've written lots of SQL queries, stored procedures, etc. I have 2GB of RAM on this PC. When I looked in Task Manager, I saw that SQL Server was using somewhere over 1GB of RAM. So, I opened up SQL Management Studio, right clicked on the server node, clicked to get to the memory configuration page and saw that SQL Server was set to use all 2GB of RAM on the PC. I changed that to 500MB(500000000, or 476MB) and decided to reboot the server. When the server came back up, I forgot to check SQL Server's new RAM usage. The server ran without interruption for over 24 hours. Now, when I checked SQL Server's memory usage in Task Manager, I can see it's using over 750MB of RAM. How do I fix this? I have Exchange Server 2003 running on this PC as well. Thx.
View Replies !
SQL Server 2005 DTS/Memory Usage
We have an application that we currently run on SQL Server 2000 that works by creating a DTS package that it then executes. Due to performance reasons, we have been considering switching to 2005, for a few reasons. Can anyone confirm clarify the following? 1) SQL Server 2000 caps RAM usage at 2GB, whereas SQL Server 2005 is only limited by the OS - RAM usage is a big current issue for us, so if upgrading to 2005 would solve this it would help a lot. Can anyone confirm my understanding of this? 2) Would using the legacy DTS in SQL Server 2005 take advantage of this RAM difference, or is it running on the old 2000 engine and only able to use the 2GB? Thanks for any help.
View Replies !
How To Explicitly Allocate An Sql Server Connection From The Connections Pool
Hello. I have a db dal containing the following code: SqlCommand cmd = new SqlCommand(); cmd.Connection = dbc; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SOME STORED PROCEDURE"; . . . declare some SqlParameters . . . dbc.Open(); cmd.ExecuteNonQuery(); dbc.Close(); This code, when concurrently running via several threads, yields the following exception: "The connection was not closed. The connection's current state is open." My questions are: 1. Why don't .Net allocate another connection from the pool (I try to only concurrently run 2 threads while there are 25 connections in the connection pool) ? 2. How can one explicitly allocate a connection? 3. How do you suggest to solve this problem without a mutex/monitor etc' on the 3 bold lines above and without BeginExequteNonQuery()? Thank you !
View Replies !
Bug ? Replikation Of Datetime Millisecond Fraction From MS SQL Server 2005 To Sybase ASE 12.5.3 Doesn't Work!
Hello, I setup a transactional push replication from MS SQL Server 2005 to Sybase ASE 12.5.3 using Sybase OLEDB Provider 2.70.00.82 (developed by DataDirect). I noticed that the millisecond fraction of datetime values are not replicated to Sybase ASE. I found out that the Parameter @status of sp_addarticle influences the replication of datetime values. If the article is configured to use 'literal string', datetime values are not completly replicated. With Sybase auditing feature I saw that statements as the following one are generated: insert into dbo.kunktable ( a , b ) values (2,'20070627 2:45:33PM') You see that the datetime value is delivered in a format without milliseconds. If the article is configured to use 'parameterized statements' everything works fine! I think it is a bug, that MS generate datetime-strings with a format which doesn't contain the millisecond fraction! You agree ? Regards Wolfgang Kunk
View Replies !
Planning For SQL Server 2005: 64-bit, OS, Processor, Memory
I was browsing Microsoft's SQL Server site, looking forsome details about SQL Server 2005. Didn't find whatI was looking for...I'm thinking about moving an existing SQL Server 2000workload to a new box, using SQL Server 2005, andmaybe the 64-bit version.My questions are:1. What is the current target date for release of SQL Server 2005?Will 64-bit ship when 32-bit ships?2. Will 64-bit SQL Server 2005 require a special versionof Windows Server 2003 (e.g. Windows Server 2003 Enterprise x64)?Will it work with both Intel and AMD processors?3. How many CPUs, and how much memory, will be supported bySQL Server 2005, 32-bit and 64-bit, on each OS that can runSQL Server 2005.I'm looking for a chart here, something like the chart onpage 117 of Kalen Delaney's "Inside SQL Server 2000" book.SQL Server 2005 SQL Server 2005Feature Enterprise 32-bit Enterprise 64-bit------------------- ----------------- -----------------CPUs supportedWin Srvr 2003:Win Srvr 2003 Adv:Win Srvr 2003 Ent x64:Physical memorysupportedWin Srvr 2003:Win Srvr 2003 Adv:Win Srvr 2003 Ent x64:Has Microsoft published this info, and I just can find it?
View Replies !
SQL Server 2005 Hogging Processor And Not Using Memory
Hi, We have recently tested upgrading our web service from sql 2000 to 2005 sp1. The upgrade went smoothly enough, however we now have the problem of the sqlserver.exe process taking 90-100 % of the processors time, but using only 100 MB of memory. We have 6GB available and we are running the enterprise editions of Windows 2003 and SQL 2005. Machine specs, DL380 G2, 2 X 2.8 Ghz Zeon, 6GB ram, Raid 5, database partition of 140 GB, Log partition of 35 GB. Db is 25 GB, Log is 12 GB. Largest table has 32 million rows. Any help would be greatly appreciated. Rob
View Replies !
Memory Stress Test In SQL Server 2005
I have a Windows 2003 Server running SQL 2005. The server has 32 GB of memory and I have enabled AWE in SQL. I have also configured the min and max SQL memory as 1 GB and 28 GB, respectively. However, this server currently has very low activity so I'm not sure whether my AWE-related changes worked. SQLSERVR.EXE process takes up about 100 MB of memory. Is there any tool or scripts that I can use to memory stress SQL to confirm that AWE is really in effect ?
View Replies !
SQL 2005 Server Performance And Maximum Memory Pro
A query was taking 20 seconds and consuming 70% CPU takes only 1 second after setting Maximum Memory property to 2048 MB - why? Server: OS Microsoft(R) Windows(R) Server 2003, Enterprise Edition Version5.2.3790 Service Pack 1 Build 3790 8 GB memory Two Dual-core AMD Opteron 285 2.6GHz Processors Server is not configured for AWE Fiber channel connection to EMC Clarion - two LUNs - one for MDF, one for LDF SQL 2005 SQL 2005 32 bit Standard Edition - SP1 (version 9.0.2047) Three instances installed on server - only one instance in use Binaries and system databases on local mirrored disk Database file (MDF) on one EMC LUN - dedicated physical drives Log file (LDF) on one EMC LUN - dedicated physical drives Query in question: SELECT TOP 10 Address.Address1, Address.Address2, Address.City, Address.County, Address.State, Address.ZIPCode, Address.Country, Client.Name, Quote.Deleted, Client.PrimaryContact, Client.DBA, Client.Type, Quote.Status, Quote.LOB, Client.ClientID, Quote.QuoteID, Quote.PolicyNumber, Quote.EffectiveDate, Quote.ExpirationDate, Quote.Description, Quote.Description2, Quote.DateModified, Quote.DateAccessed, Quote.CurrentPremium, Quote.TransactionDate, Quote.CreationDate, Quote.Producer FROM ((Client INNER JOIN Address ON Client.ClientID = Address.ClientID) INNER JOIN Quote ON Client.ClientID = Quote.ClientID) WHERE (Quote.Deleted = 0) AND ((Address.AddressType)='Mailing') ORDER BY Client.Name Address table - 161,075 rows Client table - 161,634 rows Quote table - 59,145 rows With default maximum memory setting (2,147,483,647 MB) - query runs in 20 seconds and consumes over 70 % of the CPU. After changing maximum memory setting to 2048 MB, query runs in less than 1 second. Question is: What is the best practice for setting the minimum and maximum memory settings for SQL 2005? What can be monitored to identify the cause of these type of issues - using profiler, PerfMon, other tool? Thanks
View Replies !
SQL Server 2005 Using All Memory After Installing Cumulative Update 5
Hi, I have installed cumulative update 5 (version 3215) for SQL Server 2005 SP2, and now SQL service uses 120MB of memory according to task manager. but that's not all, after this install the PF usage went up to 7.5 GB, and now the server has about 400MB of available memory. How do I know this is SQL server? if I turn the service off, the available memory goes up to 7GB and the PF usage down to 500MB It seems like SQL Server has reserved the whole memory as the process is using 120MB and not 7.5GB... as the PF shows. The machine has 4 Opteron X2, 8GB of RAM. MS Windows 2003 Server R2 Enterprise, SQL Server AWE option ON any help will be appreciated.
View Replies !
Memory Settings In SQL Server 2005 Standard Edition
Hi, I'm having trouble finding the optimum memory settings for SQL Server 2005. I have 4 instances running on a macine with 8 dual-core processors and 18GB of RAM. I have tried the following memory settings so far: No maximum - one instance used about 12GB of RAM so then the others struggled Maximum of 4GB each (2GB left for Windows) - meant that 3 instances could be using 1GB each and then another at 4GB and needing more whilst 9GB sat unused. Minimum of 2GB each - one instance would use up 10GB and then never give any back to the other instances. I also find that setting a maximum then just causes a high amount of paging. What I would like to do is have each instance use a minimum amount, say 1GB, and then have each instance use a maximum of 13GB (3GB for other 3 instances running at a minimum level and 2GB for Windows). This 13GB should then be released and allocated to another instance when necessary, assuming it is no longer all being used. I do not want paging to occur if an instance reaches 13GB. How do I go about configuring SQL Server to behave like this? Is it possible? Thanks.
View Replies !
SQL 2005 Server Performance And Maximum Memory Property
A query was taking 20 seconds and consuming 70% CPU takes only 1 second after setting Maximum Memory property to 2048 MB - why? Server: OS Microsoft(R) Windows(R) Server 2003, Enterprise Edition Version 5.2.3790 Service Pack 1 Build 3790 8 GB memory Two Dual-core AMD Opteron 285 2.6GHz Processors Server is not configured for AWE Fiber channel connection to EMC Clarion - two LUNs - one for MDF, one for LDF SQL 2005 SQL 2005 Standard Edition - SP1 (version 9.0.2047) Three instances installed on server - only one instance in use Binaries and system databases on local mirrored disk Database file (MDF) on one EMC LUN - dedicated physical drives Log file (LDF) on one EMC LUN - dedicated physical drives Query in question: SELECT TOP 10 Address.Address1, Address.Address2, Address.City, Address.County, Address.State, Address.ZIPCode, Address.Country, Client.Name, Quote.Deleted, Client.PrimaryContact, Client.DBA, Client.Type, Quote.Status, Quote.LOB, Client.ClientID, Quote.QuoteID, Quote.PolicyNumber, Quote.EffectiveDate, Quote.ExpirationDate, Quote.Description, Quote.Description2, Quote.DateModified, Quote.DateAccessed, Quote.CurrentPremium, Quote.TransactionDate, Quote.CreationDate, Quote.Producer FROM ((Client INNER JOIN Address ON Client.ClientID = Address.ClientID) INNER JOIN Quote ON Client.ClientID = Quote.ClientID) WHERE (Quote.Deleted = 0) AND ((Address.AddressType)='Mailing') ORDER BY Client.Name Address table - 161,075 rows Client table - 161,634 rows Quote table - 59,145 rows With default maximum memory setting (2,147,483,647 MB) - query runs in 20 seconds and consumes over 70 % of the CPU. After changing maximum memory setting to 2048 MB, query runs in less than 1 second. Question is: What is the best practice for setting the minimum and maximum memory settings for SQL 2005? What can be monitored to identify the cause of these type of issues - using profiler, PerfMon, other tool? Thanks
View Replies !
Memory Usage Of SQL Server 2005 Mobile Edition
Hi forum readers, we are working on a release 2.0 mobile solution right now. In our version 1.0 we did not have to worry about memory issues as our application was the only application running on our target devices (e.g. T-Mobile MDA Compact II Pocket PCs, WM2005). Now we need to share the available memory with others. As our application relies on its SQL Server 2005 Mobile Edition database we are wondering about memory usage of that server. We know that a Pocket PC divides its memory into Storage and Program. If our application uses a 5 MB database and 1.5 MB for DLLs and it's exe-file. These files reside in the storage space when not loaded. When the application starts up it is loaded in the program memory. What happens to the 5 MB database file? Is is loaded into Program memory as well? Are only portions of that file loaded? Or is nothing loaded at all? Does anyone have a deeper insight into that server an can answer my questions. Best regards, Tobias
View Replies !
Performance Issues Total Server Memory Vs Target Server Memory
Hi I did a load testing and found the following observations: 1. The Memory:Pages/sec was crossing the limit beyond 20. 2. The Target Server Memory was always greater than Total Server Memory Seeing the above data it seems to be memory pressure. But I found that AvailableMemory was always above 200 MB. Also Buffer Cache HitRatio was close to 99.99. What could be the reason for the above behavior?
View Replies !
SQL Server 2005 Workgroup Edition In SBS 2003 R2 Max Memory Question
We have only a small busines and haven't got too much experience with servers and now have a proliant server coming in with SBS 2003 R2 Premium with the 4 GB max memory that SBS 2003 can handle according to the specs. We weren't planning on using the SQL 2005 worlgroup edition up till now, but now we might. According to the specs of SQL server 2005 workgroup edition however, it has a max RAM of 3GB! Is this going to be a problem and should we keep using our previous DB, or can we migrate toward SQL server with the 4 GB of RAM?
View Replies !
SSIS Doesn`t Start After Applying SQL Server 2005 SP1 Error Message 7000 Service Control Manager
SSIS doesn`t start after applying SQL Server 2005 SP1 I get an error Message in event log event id 7000 source: Service Control Manager Type: Error Message: The SQL Server Integration Services service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. regards Lothar Belle
View Replies !
How To Make Use Of 4 GB Memory For SQL Server 2005 Standard + Windows 2003 Stardard
We just upgraded the memory of our database server from 2GB to 4GB. And its OS is windows 2003 standard and sql is 2005 standard edition. According to microsoft(http://msdn2.microsoft.com/en-us/library/ms143685.aspx and http://msdn2.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2003), this configuration should allow database use up to 4 GB memory. My question is : Do I need to do anything(such as: adjust the maximum memory in management studio) to let our server be able to consume this extra 2 GB memory? Does this solution http://support.microsoft.com/kb/274750 apply for SQL server 2005?
View Replies !
SQL SERVER EXPRESS BETA1 (2005) IS NOT RUNNING :SHARED MEMORY Provider Error
I'm facing several problems that I tryied to short out by msdn but could not get solution I'm using visual studio .NET 2005 Beta(WHIDBEY),and problem:1 sql server2005 Express edition is not running on My stand alone machine(AMD Athlon Xp 2000+,512 MB DDR Ram,CPU Clock speed 1.67 GHz) Whenever I try to connect to SqlExpress using the server explorer in the VisualStudio.NET 2005 using follwing option in connection properties Dialog Box : 1.server name: the name of my computer(I'm using the Default Instance of SQLEXPRESS 2005) 2.Enter Information to log on to the server:usewindowsNt Integrated Security3.when I go to select the inuilt data base like masters it gives following Error message:- "Shared memory provider:Specifed Module could not be Found" problem:2In the process of making of Data Access component,I made an assembly named "TNB.DataLayer.CSharp.dll" and putted it at two place one in the ..in folder and another in the folder having the solution file .Now I want this asssenbly to put in Global Assembly cache so that parts of my project (a window Application and a Web Application) can access the database using this TNB.DataLayer.CSharp.dll Now i need to make my assembly a strong name so I used following at the .NET command Prompt sn.exe -k TNBKeyPair.snkand put this file in the folder where My solotion .sln file exist.now as I have the keypair file,I tryied to sign the assembly TNB.DataLayer.CSharp.dll with this key for this when I added the following in to the AssemblyInfo.cs file[assembly: AssemblyKeyFileAttribute("TNBKeyPair.snk")] warning on bulding the solution is Warning 1: Use command line option '/keyfile' or appropriate project settings instead of 'AssemblyKeyFileAttribute' D:gopaldot net newTNBTNBPropertiesAssemblyInfo.cs 19 11 and when I use the /keyfile:TNBKeyfile at the command prompt I got another Error message:The file name, directory name, or volume lable syntax is incorrect. and finally I'm not able to sign the Dll and to put it in global assembly to use from different envioronments. so please help me in solving this problem. Thanks! ur faithfully
View Replies !
SQL Server 2005 Service Broker - Activation Stored Procedure Memory Usuage
We are looking for some guidance with an issue we have picked up with our implementation of Service Broker here on the ABSA Capital project and I am hoping you can help or point us in the direction of someone. The architecture we have implemented for service broker is to make use of an Activation stored procedure on two queues (1 SP per queue) to process the messages received. What we have found is that the activation stored procedure runs on a background session and its CPU time and memory just grows to the point where it brought one of our UAT servers to a grinding halt. Is there anyway we can reduce the memory consumption of the activation stored procedure or is this one of those things that still need to be ironed out in Service Broker?
View Replies !
Sql Server 2000 Using Less Memory After More Memory Added
sql server 2000 is running on windows server 2003 ... 4gb of memory on server .... 2003 was allocated 2.3gb nd sql server was allocated (and using all of it) 1.6gb for total of approx 4gb based on idera monitor software ... all memory allocated betweeen the OS and sql server .... then 4 more gb of memory added for total now of 8g ... now idera monitor shows 1.7gb for OS and 1.0 gb for sql server ..... 'system' info shows 8gb memory with PAE ... so I assume that the full 8gb can now be addressed .... why are less resources being used now with more total memory .... especially sql server ..... i thought about specifying a minimum memmry for sql server but i amnot convinced that would even work since it seems that this 1gb limit is artificial .... it it used 1.6 gb before why would it not use at least that much now ?? thank you
View Replies !
Bit-data From SQL Server 2000 (2005 Working, 2000 Doesn't)
Hi, I am trying to edit some data from a SQL2000-datasource in ASP.NET 2.0 and have a problem with a column that has bit-data and is used for selection. SQL2005 works fine when declaring <SelectParameters> <asp:Parameter DefaultValue="TRUE" Name="APL" Type="boolean" /> </SelectParameters>When running this code with SQL2000, there are no error-msgs, but after editing a record the "APL"-column looses its value of 1 and is set to 0. Looks like an issue with type-conversion, we've hit incompatibilities between SQL200 and 2005 with bit/boolean several times before. So, how is this done correctly with SQL2000? (I've tried setting the Type to "int16" -> err. Also setting Defval="1" gave an err) ThanksMichael
View Replies !
&&"Not Enough Memory For Operation&&" - Sql Server 2005
My Microsoft Visual Basic 6.0 application uses Crystal Reports 8.0 as the reporting development tool. After the application is distributed to a client computer, when the application attempts to load a report the following error message appears: "Not enough memory for operation" NOTE : The report file uses Stored procedure to process the query and display data. And the client computer is using SQL Server 2005. However, if we install SQL Server 2000, the report generates without any problem. Moreover in client computer niether MsDtsSrvr is not seen in Running process list (Task manager) nor I am unable to start MsDtsSrvr.Kindly help me on this issue. Thanks in advance, Nethesh Kannan
View Replies !
Alert Doesn't Work On SQL 2005
Hi,I have trouble getting the alerts to work on SQL 2005.Below I define a custom message and a custom alert.When I raise the error though the alert never fires.Any ideas why that would be?Thanks,Patrick-------------------------------------------------------USE masterGOEXEC sp_addmessage 50001, 16, N'The version of SQL Server has beenrequested.'GO------------------------------------------------------USE [msdb]GOEXEC msdb.dbo.sp_add_alert @name=N'TEST Alert',@message_id=50001,@severity=0,@enabled=1,@delay_between_responses=5,@include_event_description_in=5,@notification_message=N'TEST',@category_name=N'[Uncategorized]',@job_id=N'00000000-0000-0000-0000-000000000000'------------------------------------------------------RAISERROR (50001, 16, 1)------------------------------------------------------
View Replies !
Why This Trigger Doesn't Work In Sql 2005
hi eveyrone, I have an after insert trigger that works in sql2000 but not in sql2005. Can you please help me!! CREATE trigger dbo.trUPS_tbl_I on dbo.UPS_tbl After Insert --For insert as declare @Tracking varchar(800), @UPSID varchar(10), @Cmmd varchar(800) select @UPSID = cast(inserted.UPSID as varchar) from inserted commit set @Cmmd = 'c:TasksUpdTrackingUpdateTrackingCS ' + @UPSID + ' ' + 'UPS1' EXEC master.dbo.xp_cmdshell @Cmmd The UpdateTrackingCS program will call a stored procedure to get the inserted data and update other databases. And the reason to put the commit statement in sql2000 is to have sql commit the transaction, so the store procedure in UpdateTrackingCS can query thtat inserted records. When I use the same code in SQL2005, no matter what I do the UpdateTrackingCS program cannot query the data by the UPSID. It always says record not found. I have tried to change commit to begin trans ... commit trans. But nothing works. Please help! Thanks in advance. lyw
View Replies !
Why This Trigger Doesn't Work In Sql 2005
hi eveyrone, I have an after insert trigger that works in sql2000 but not in sql2005. Can you please help me!! CREATE trigger dbo.trUPS_tbl_I on dbo.UPS_tbl After Insert --For insert as declare @Tracking varchar(800), @UPSID varchar(10), @Cmmd varchar(800) select @UPSID = cast(inserted.UPSID as varchar) from inserted commit set @Cmmd = 'c:TasksUpdTrackingUpdateTrackingCS ' + @UPSID + ' ' + 'UPS1' EXEC master.dbo.xp_cmdshell @Cmmd The UpdateTrackingCS program will call a stored procedure to get the inserted data and update other databases. And the reason to put the commit statement in sql2000 is to have sql commit the transaction, so the store procedure in UpdateTrackingCS can query thtat inserted records. When I use the same code in SQL2005, no matter what I do the UpdateTrackingCS program cannot query the data by the UPSID. It always says record not found. I have tried to change commit to begin trans ... commit trans. But nothing works. Please help! Thanks in advance. lyw
View Replies !
Can't Allocate Space
Hi, I've got a table with 65'000 records and when I do a SELECT * FROM tablename ORDER BY Name I receive this error message: Msg 1105, Level 17, State 1 Can't allocate space for object '-513' in database 'tempdb' because the 'system' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment. Msg 1510, Level 17, State 2 Sort failed: Out of space or locks in database 'tempdb' So I've dumped the transaction with no_log and also I've extended the segement from the master database (because tempdb is in it bydefault): sp_extendsegment system, master But I've still got the error message. Is there anybody who can advice me? Thank you
View Replies !
Sql 2005 Xml Modify Doesn't Support Variable?
when I use xml.modify, I was told the first parameter has to be a string literal. I can not believe it, usually people store dynamic fields into xml, if the modify don't support variable, it is really not much useful. I can have a .net function to achieve that, but I think SQL should provide an native function that work with variable. Any idea?
View Replies !
2000 Active X Doesn't Work In 2005
I have an active x script written in vb that just counts the records in a table and fails the step if there are not enough records. It is simple and effective. But when I transfered this task to my SSIS package I get a function not found error. I am not familiar with active x or vb script so I have no idea what is wrong. I can do without while I build the package but I need it in the end to prevent possible problems.... Here is the script... '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() dim myConn dim myRecordset dim iRowCount ' instantiate the ADO objects set myConn = CreateObject("ADODB.Connection") set myRecordset = CreateObject("ADODB.Recordset") ' Init ADO Connection object With myConn .ConnectionString = "File Name=D:Data Linksmusic_load.udl;" 'Full path to the UDL .Open End With mySQLCmdText = "Select 'totalcount' = Count(*) from fulltext" myRecordset.Open mySQLCmdText, myConn set Flds = myRecordset.Fields set iRowCount = Flds("totalcount") If iRowCount.Value < 1000000 then ' MsgBox "The number of products is: " & iRowCount.Value & ". The total number is wrong" Main = DTSTaskExecResult_Failure Else ' MsgBox "The number of products is: " & iRowCount.Value & ". The total number is good" Main = DTSTaskExecResult_Success End If End Function
View Replies !
Could Not Allocate Space For .. Error
I am getting a "Could not allocate space for object 'temp_trc' in database'Test' because the 'PRIMARY' filegroup is full"The database test has unrestricted growth (All the defaults). It resides ondrive c which has 4Gigs free. I added new data and log files on drive dwhich is about 30G free. I know that my insert doesn't take even 1G diskspace.Why is the database complaining about a full filegroup when I just expandedit?J.
View Replies !
Lottery / Allocate Number
I’m hoping someone can help me create a ‘lottery’ for records in a table. I have a table called tblPoints with a number of fields including Application_ID, Total_Points and Place_No. The following is a sample of the data Application_ID Total_PointsPlace_No 87 105 68 95 49 75 96 75 155 75 156 70 144 70 146 70 At the moment there is no data in the Place_No field. I want to assign a Place_No to all records based on the number of Points (Total_Points). The highest Points value should have a place Number of 1 and so on. Application_IDTotal_PointsPlace_No 871051 68952 4975 9675 15575 15670 14470 14670 However, where a number of applications have the same points I want to randomly allocate a place number for them. Application_ID 49, 96 and 155 all have 75 points so each of the 3 applications should be randomly allocated one of the following place numbers, 3, 4 and 5. I can not allocate them based on their order in the table as it has to be seen as a ‘lottery’ and each time it is run they would expect to get a different result. The same thing then has to happen with the last 3 records in this sample allocating place numbers 6, 7 and 8 I was hoping to create a stored procedure to do this, but I’ve no idea where to begin. I would appreciate any help you could give. Thank you. C
View Replies !
SSIS FTP Task Doesn't See Files Which Are There (MSSQL 2005)
Hi, I'm trying to create an SSIS package to get a file from AS400. I can get a file via FTP from the command line, and the FTP connection in SSIS tests successfully, but the FTP task fails with a "file not found" error. When I view the contents of the AS400 using the ellipsis (FTP Task Editor > File Transfer > Remote Path), many directories and files are not visible. Any suggestions? Thanks, Elias
View Replies !
|
TRACKER
