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 Complete Forum Thread with Replies
Related Forum Messages:
Cumulative Update 3 Of SQL Server 2005 SP2 Contains A Service Broker Fix
The CU3 of SQL Server 2005 SP2 was just released on the web, http://support.microsoft.com/kb/939537 It contains an update to Service Broker: 50001416 940260 (http://support.microsoft.com/kb/940260/) FIX: Error message when you use Service Broker in SQL Server 2005: "An error occurred while receiving data: '64(The specified network name is no longer available.)'" The title of the fix is derived from the original incident case, but the fix is actualy for the one case that would lead to 'leaked' conversation endpoints on the target in remote scenarios (communication between two different SQL Server instances) was fixed. The case fixed is when the pattern of message exchange is correct: - Initiator sends one or more messages - Target issue END CONVERSATION and sends the EndDialog message - Initiator receives the EndDialog and responds by issuing it's own END CONVERSATION The defect was that if the initiator issues the END CONVERSATION within 1 (one) seconds of the target sending the EndDialog message, the target endpoint was 'leaked'. Note that this fix does not address local cases (two databases within the same SQL Server instance) nor the case of remote 'incorrect' message exchange pattern, when the initiator ends the conversation first w/o ever receiving any message from the target.
View Replies !
Installing The Cumulative Hotfix Onto Express
So today I decided I may as well put the latest hotfix package for Sql 2005 onto my laptop. Unlike SP1 the hotfix actually seemed to know about SQL Express and attempt to install itself only to collapse in a big heap. The log file indicates it can't find a bunch of files it wants to patch. So how do I apply the hotfixes to Express?
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 !
Which Cumulative Update Package For Sp2
Hi I have found two cumulative update packages available for sql 2005 sp2 - build 3161 (http://support.microsoft.com/kb/935356) and build 3175 (http://support.microsoft.com/kb/936305). The fixes are supposed to be cumulative and include all fixes since the last service pack, but the list of hotfixes in each package is different. Does build 3175 contain the fixes in build 3161? What about fixes mentioned in build 3175 that have version lowere than 3161 - are they included in build 3161? Anthony
View Replies !
Cumulative Update Package 2 For SP2
I tried to install "Cumulative update package 2 for SQL Server 2005 Service Pack 2" Everything went well except for the "SQL Server Database Services" update. It errored out as it was trying to "Finalize" the update. Kicker to this whole thing is the database file "temp_MS_AgentSigningCertificate_database.mdf" does not even exist. I could not see any references to it in the master database. I checked the registry and I can find a couple of search references for it. It apparently may have been a database that existed in the server at one time. I am not sure if I should remove the registry references to the database. Below is a part of the install summary where it has failed: =========================================================== Product Installation Status Product : SQL Server Database Services 2005 (MSSQLSERVER) Product Version (Previous): 3050 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB936305_sqlrun_sql.msp.log Error Number : 29537 Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]A file activation error occurred. The physical file name 'F:Data emp_MS_AgentSigningCertificate_database.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.. To continue, correct the problem, and then run SQL Server Setup again. If someone can tell me what I need to do to resolve this issue, I would greatly appreciate it. Thanks, Larry :-( Larry :-)
View Replies !
SSRS And SQL2K5 SP2 Cumulative Update 5
Hi, Are there any known issues when installing SQL2K5 SP2 with or without Cumulative Update 5? I have a report which contains a hierarchy of matrix controls using rectangles with a corresponding document map so that a user can view the data in a matrix with varying degrees of granularity. Page breaks are used to ensure that the matrix for the selected node is displayed in the browser. When exported to Excel, the document map works as desired so that when users expand the hierarchy and click on a link, they are taken to the corresponding location in the worksheet containing the exported data; all of which is contained in a single worksheet. Here's the problem. I have installed SQL2K5 SP2 Cumulative Update 5 on my development machine. The production SSRS machine is only running SP1 and there seem to be some differences in the RDL schema and/or the output when rendering to HTML and Excel. The RDL schema is not interchangeable between the two versions. If I copy all code contained in the <Body></Body> tags from the production version into the development version, I get some errors indicating that there is a problem at the root level. HTML navigation works using page breaks so that when the user clicks on a node in the document map, they see the corresponding matrix on it's own page in the browser. However, when exporting to Excel, two worksheets are displayed after the document map and most of the data is missing. If I remove the page breaks, I can get the Excel version to display all of the individual matrix controls and navigation from the document map worksheet to the data worksheet works. However, the HTML version displays multiple matrix controls per page and clicking on a node in the document map doesn't result in intuitive navigation, if any. If I add the page breaks back in so the HTML navigation displays the desired matrix on a single page and modify RSReportServer.config so that OmitDocumentMap is set to true for the Excel renderer, I get no document map and the data is chopped after the first couple of matrix tables. Has anyone experienced similar behaviour? Is there something that can be done to get my SP2 Cumulative Update 5 to behave like the SP1 production copy? Do I have to roll my machine back to SP1 in order to return to the desired functionality? Lots of questions. Thanks in advance for any help. Bill
View Replies !
Installing IIS After Installing SQL Server 2005 And Visual Studio 2005 Help Requested!
Hi all, Im new here so il start with a little introduction of myself, My name is Arjan im 19 years old from Holland, and i work for a company to compleet my ICT Education. My situation: My boss gave me a server with server 2003 standard and Sql server 2005 and visual studio 2005 installed already, he asked me if i could figure out how the 'new' reporting services work, Im pretty new to SQL and the reporting service but i figured out i had to install asp.net / frameworks and IIS. So right now i wanna start the Reporting Services Configuration Manager and i get an error that says 'Invalid namespace' and when im trying to approach by using my browser i get 'page not found' so obviously their is Alot wrong. I asked my boss if i could not reinstall everything and do it in the correct order (IIS / ASP.net / Frameworks before installing SQL server 2k5 but that was not an option because we dont seem to have the cd's anymore. The server is not connected to any network or the internet. My Question: Is their any way to fix this? and if yes could anyone tell me where to start Thanks in Advance! ps if their is information or logs that u need in order to help me just say so :-) -Arjan
View Replies !
Is Microsoft Going To Include KB940287 In A Cumulative Update?
Re: KB 940287 - Will it be in a Cumulative Update? SYMPTOMS: You use Service Broker in SQL Server 2005. When the initiating service starts a conversation and then sends a message, the initiating service ends the conversation immediately. However, after the target service processes the message, the endpoint on the target server is not deleted when the target service ends the conversation. Therefore, when the initiating service starts a new conversation, the number of the conversation endpoints on the target server keeps increasing. Additionally, you receive the following error message on the initiator server: An error occurred while receiving data: '64(The specified network name is no longer available.)' This message could not be delivered because the conversation endpoint has already been closed. It has several workarounds. I've not been affected by this yet, but KB says it has a hotfix that has been out since July 2007, so it is curious that it has not been put into a Cumulative Update yet, at least as far as documentation in Knowledge Base is concerned. Does anyone know any more about this? Paul
View Replies !
Cumulative Update 5 Build 9.00.3215 KB - Problem
Cumulative Update 5 Build 9.00.3215 KB - Problem http://support.microsoft.com/kb/943656/ We contacted Microsoft and installed the update, but when I do a SELECT @@Version I still get build 3042. I'm not sure if they sent us the wrong file or if the update didn't apply correctly. Under Add/Remove Programs SQL Native Client shows the new build 3215 though. Microsoft sent us 335091_intl_i386_zip.exe This extracted to.. hotfix.txt sqlncli.msi Any ideas? Thanks in advance!
View Replies !
Un-Installing And Re-Installing SQL Server 2005
Recently I decided to upgrade my SQL Server 2000 to SQL Server 2005 Express Edition. Because I will not need SQL Server 2000 anymore I un-installed it. At first the SQL Server 2005 Express Edition worked fine. Subsequently, I had to return to SQL Server 2000, so I uninstalled SQL Server 2005. Even though I completed that I never used the SQL Server 2000 installation after all, so after a while I decided to uninstall it again and re-install SQL Server 2005 Enterprise Edition this time. The entire installation process appears to have completed successfuly, except that when I load SQL Server Management Studio 2005 it displays two instances to choose from. One is for the old MYSERVERSQLEXPRESS instance and one is for my MICROSOFTSMLBIZ instance. The SQLEXPRESS instance cannot be connected to at all. I've even tried to connect to my SERVERNAME without the SQLEXPRESS and it still does not connect. I get a message about Remote Connections not being allow. During a previous installation I was able to connect to my MICROSOFTSMLBIZ instance, but could not use many of the SQL Server tools and functions, such as COPY DATABASE, CREATE DATABASE, etc. On top of this I have also noticed that none of the SQL Server Services appear in the Services section. I don't even see the Microsoft SQL Server Browser Service. Not a single service named "Microsoft SQL Server" appears. Subsequently, I un-installed SQL Server 2005 and re-installed it again. Again, it appears to have installed fine. Yet, I cannot connect to any instance of my SQL Server 2005, rendering it useless. I've now un-installed it again and am going to try installing SQL Server 205 Express just to see if that will work, since MYSERVERSQLEXPRESS appears by default. Maybe then I'll be able to use it. Just seems though that performing a complete install should result in a successful installation. I've looked up Manually Un-Installing SQL Server 2005, but that looks risky to me. Is there any simple way to have my instance of SQL Server 2005 completely removed from my computer so that I can perform a new clean install of SQL Server 2005 so that it will work? I'm at a total lose now and have invested many hours in installing and un-installing SQL Server 2005. I'm wondering now if all these installs are only making the overall problem get worse. My apologies for such a long drawn out post, but I am really in need of some help. Any help anyone can give would be greatly appreciated. Thank You. Greg
View Replies !
Installing SQL Server 2005 Standard Edition When Express 2005 Is Already On Server
I need to install SQL Server 2005 Standard Edition on a new Windows Server 2003 machine that has SQL Server 2005 Express Edition installed by a backup application (Backup Exec). Will I need to uninstall the express edition in order to install the standard edition? Can the two coexist as separate instances or will the standard edition installation simply upgrade the express installation? Thanks
View Replies !
Installing MS Visual Studio 2005 (PE). On Vista X64 (BE) Running MS SQL Server 2005 (DE) X64
Hi, I am running SQL Server 2005 x64 DE on Vista x64. I installed MS VS 2005 Pro. Edition. During the setup of VS, I did a custom install, un-checking the SQL Express addition box. After installation, I received errors that indicated the SQL Express did not install. Even though I do not have SQL Express installed on my machine, MS Update says that I need SQL Express SP2. My SQL DE is up to date with SP2 and MS Update indicates as "optional" that I need SQL SP2. Is SQL Express a necessity for VS Pro? If not, why is MS Update indicating that I need SQL Express SP2? In addition, why is MS Update telling me I need SQL SP2 when it is already installed? Note: I installed SQL SP2 manually, not through MS Update. This makes me believe that MS Update is not detecting it. Thanks in advance to anyone who can help, Abel
View Replies !
Sql Server 2005 (business Intelligence Development Suite ) Problem Installing Sql 2005 On Vista (vs 2008)
I installed sql server 2005 sp2 including business intelligence development suite , however I got a message some client components not compablitable .This morning I searched my programs and found that I have new visual studio 2005 on my computer (before I just had vs 2008) as well as business intelligence developer (which does not work) It seems I I would like to get rid of vs 2005 also fix business intelligence studio . Previously I deleted vs 2005 express off my computer........(I have vista and I would only like to keep tools meant for sql standard 2005 reporting services etc here is a list of my sql sp2 install package By the way I doubled clicked sql_tools.msi and did not run as administrator Does that make a difference? I wonder if this is a problem with vs 2008 and sql 2005...... Time: 05/06/2008 20:49:23.437 KB Number: KB921896 Machine: BILLPREC690 OS Version: Professional (Build 6000) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: Cluster Installation: No ********************************************************************************** Prerequisites Check & Status SQLSupport: Passed ********************************************************************************** Products Detected Language Level Patch Level Platform Edition Setup Support Files ENU 9.00.1399.06 x86 Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD Analysis Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD Reporting Services (MSSQLSERVER) ENU RTM 9.00.1399.00 x86 STANDARD Notification Services ENU RTM 9.00.1399.00 x86 STANDARD Integration Services ENU RTM 9.00.1399.00 x86 STANDARD SQL Server Native Client ENU 9.00.3042.00 x86 Client Components ENU RTM 9.00.1399.06 x86 STANDARD SQLXML4 ENU 9.00.1399.06 x86 Backward Compatibility ENU 8.05.1054 x86 Microsoft SQL Server VSS Writer ENU 9.00.1399.06 x86 ********************************************************************************** Products Disqualified & Reason Product Reason ********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID SQLWriter Microsoft SQL Server VSS Writer Service 2700 ********************************************************************************** Product Installation Status Product : Setup Support Files Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Database Services (MSSQLSERVER) Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Reboot Required Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 3010 Error Description : ---------------------------------------------------------------------------------- Product : Analysis Services (MSSQLSERVER) Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Reporting Services (MSSQLSERVER) Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB921896_sqlrun_rs.msp.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Notification Services Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB921896_sqlrun_ns.msp.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Integration Services Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : SQL Server Native Client Product Version (Previous): 3042 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlncli.msi.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Client Components Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Reboot Required Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log Error Number : 3010 Error Description : ---------------------------------------------------------------------------------- Product : SQLXML4 Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlxml4.msi.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Backward Compatibility Product Version (Previous): 1054 Product Version (Final) : 2004 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Microsoft SQL Server VSS Writer Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlWriter.msi.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- ********************************************************************************** Summary Success, Reboot Required Exit Code Returned: 3010
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 !
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 !
Cumulative Wait Time On Server Replies ???
Hello all,I've got a query which suddently became very slow. It now takes about 10secs instead of 2 secs.I've got to identical DB (one is for test and the other is production). Thequery is slow only in production.When running this query in both DB and looking at execution plan,statistics, etc, the onle difference is the Cumulative wait time on serverreplies.In test DB, I get the value: 2200And in production DB: 1.22344e+009What does this mean concretly? What do I have to do to solve this problem?TIA.YannickPS I'm using SS2000 SP3 on NT4.0
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 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 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 !
Installing SQL Server 2005
Hi, During the installtion of SQL Server 2005 (Win2k3 SP2) the msxml setup fail. When i try to install manually the msxml i get the error "the system administrator has set policies to prevent this installation". I'm the machine administrator. Someone can help me?
View Replies !
Need Help In Installing VS.NET, VSS, SQL Server 2005
As far as the installation of Sql server 2005 on the server what CD do I use? Is it the 18).SQL Server 2005 Enterprise Edition SQL Server 2005 Enterprise Edition 64-bit Extended SQL Server 2005 Enterprise Edition for Itanium-based Systems SQL Server 2005 Standard Edition SQL Server 2005 Standard Edition 64-bit Extended SQL Server 2005 Standard Edition for Itanium-based Systems (English Disc 3545 May 2006) in the above mentioned list? or just again the 17).SQL Server 2005 Developer Edition ? I'd still use Disk 17 unless there was a particularly good reason why you'd want Enterprise on there. E.g. Database Partioning, Parallel Index Operations or Indexed views. Although really my decision is: does the client run SQL2005 Standard (then I'd use Dev), or SQL2005 Enterprise (then I'd use Enterprise). I've never had to install SQL2005 Enterprise :-)
View Replies !
Installing SQL 2005 Server
I believe when I installed VB 2008 Express Edition, it also installed SQL Server 2005, so I do not need to install SQL Server 2005 Express Edition, correct? Thanks, Dave (aka "da noob")
View Replies !
Installing Sql Server 2005
Hi all, i've searched forum and haven't found anything interesting for my problem. I have installed SQL server 2005 (enterprise) 32-bit and have run SQL server Management Studio. (using: Windows XP) What/how shall I install/connect to a server name (database engine)? I have AdventureWorks and would like to use it in Management Studio. thank you for your help. :)
View Replies !
Installing SQL Server 2005
Hello I am trying to install SQL Server 2005 on XP with SP2. According to Microsoft this should be sufficient. However when I try to install it says I need WIndows Installer 3.1. I cannot get this from Microsofts website as i'm not using a proper copy of XP. Does anyone know a way round this before I go and buy XP? This is the file I need... WindowsInstaller-KB893803-x86.exe To complicate matters further i'm running XP on my Mac via Virtual PC (but i'm told this shouldn't matter) Thank you in advance
View Replies !
Installing MS Sql Server 2005
I have a problem. I downloaded SQL server 2005 "standard or develope" trial version, which did not install on my computer. Probably not working on my OS. So the trial version did not work. Could someone please give me a clue which version that would work?? My OS an SP-level is; Windows XP Professional Version 5.1 (Build 2600.xpsp_sp2_gdr.050301-1519: Service Pack 2) (Windows XP Professional version 2002 32-bit, Windows XP Service Pack 2, IIS, .NET Framework 2.0., 13GB free space, processor intel 1,5 GHz, 256MB RAM)
View Replies !
Help With Installing SQL Server 2005
Hi, I was wondering if anyone might be able to help me. I was trying to run SQL Server 2005 express edition after downloading it from the internet. I must admit i'm new to SQL server. So this is why i like to get a feel of how it works and that sort of things. However, when i tried to run it, it's saying that i needed .Net Framework 2. Then, after having downloaded the .Net and run the setup, the error message came up with the following message. "Error creating process <c:Documen~1userslocals~1 empixp000.TMPInstall.exe>. Reason: c:windowssystem32advpack.dll" It still gives me the same error message after updating the advpack.dll i got from the internet. Has anyone had the same experience as i've been having now? Any ideas as to solve it? Thank you in advance
View Replies !
Installing SQL Server 2005
Hello Friends, I need to install SQL server 2005 in my desktop. I have already installed Visual Studio 2005 and selected to install all add ons during initial installation of VS 2005. Now, when i inserted my CD for installing SQL server 2005, there is nothing that has to be installed. I checked that SQL 2005 Express edition is already installed in my system. Kindly let me know, if by installing VS 2005 with all add ons will install SQL server 2005 as well? Many thanks. Regards, Ramki
View Replies !
New On Installing SQL Server 2005
Hi, I've installed SQL server 2005 (enterprise edition) and started SQL Server Management Studio; and I don't have any servers nor databases. What shall/can I do in order to get (at least) a sample database (eg. Adventureworks) getting started. Thank you for anykind of help.
View Replies !
Installing Sql Server 2005
While i try to install Sql Server 2005 this message appears : "Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online." What can i do? I am trying to install Sql Server 2005 Enterprise Edition on Windows XP Professional SP2.
View Replies !
SQL Server 2005 Is Not Installing
Hi All, When i am going to install SQL Server 2005, its coming error "provide unique instance name". The error is coming on "SQL Server Database Service". All the service get installed with out any error. I have select "default instance". Please help me to resolve this issue. Thanks Abhi
View Replies !
Installing SQL Server 2005
Hello Friends, I need to install SQL server 2005 in my desktop. I have already installed Visual Studio 2005 and selected to install all add ons during initial installation of VS 2005. Now, when i inserted my CD for installing SQL server 2005, there is nothing that has to be installed. I checked that SQL 2005 Express edition is already installed in my system. Kindly let me know, if by installing VS 2005 with all add ons will install SQL server 2005 as well? Many thanks. Regards, Ramki
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 !
Installing SQL Server 2005 Express
Is it possible to install SQL Server 2005 Express on a machine that restricts installs by using ClickOnce?For example, I can't install new applications on my machine at work unless I use ClickOnce to do so. I want to be able to use SQL Server 2005 Express in my applications and move away from MS Access.
View Replies !
Installing MS SQL Server 2005 Developer
I've done this before but it's been sometime. When I finish installing the MS SQL Server 2005 Developer edition, all I see under the Microsoft SQL Server 2005 folder in the All Programs is Configuration Tools with the following shortcuts: Notification Services Command PromptSQL Server Configuration ManagerSQL Server Error and Usage ReportingSQL Server Surface Area Configuration The are a whole bunch of other programs inside the Microsoft SQL Server 2005 folder that are missing. How do I add those services or program such as the Microsoft SQL Server Management Studio?
View Replies !
Installing SQL Server 2005 Developer
Hello, When installing SQL Server 2005 developer, I get the error: Product : Visual Studio Integrated Development Environment 2005Error : Internal Error 2356. _14248_Microsoft_VC80_MFC_x86.msm Any idea why this is happening? Thanks.
View Replies !
|
TRACKER
