March 15, 2006 at 9:16 am
I have a SQL server 2000 working on a Windows 2000 server (cluster mode). Each servers is running with 4.Gb of ram but Sql server is only using 2GB.
My databases have recently been running slow. How can I find out where the problem is and how can I increase the memory been use by SQL SERVER to 3Gb.
March 15, 2006 at 9:29 am
Charles
Add the /3GB to the boot.ini file on both cluster nodes. This will allow SQL Server (and any other applications) to grab 3GB while reserving only 1GB for the OS. If you search for "/3gb" on Microsoft's website you should find how to do this.
Finding out where the problem is is a big question to ask. The sql-server-performance.com website has got some great ideas for monitoring and performance tuning to get you started. Don't assume just because SQL Server is only using 2GB of memory that this is necessarily the problem. Perfmon, Profiler and the Index Tuning Wizard may be your greatest friends here.
John
March 16, 2006 at 12:40 pm
If you use Windows 2000 Server ( not Advanced Server, right?) then you cannot use the 3 GB switch
in the Boot.ini file with Windows 2000 Server; however, you can use the 3 GB switch in the Boot.ini file with
Microsoft Windows 2000 Advanced Server or Microsoft Windows Datacenter versions
March 17, 2006 at 6:35 am
It's a cluster server so I imagine it must be Advanced Server.
John
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply