comp.databases.ms-sqlserver - Microsoft's SQL Server and related products.
I have MS SQL 2000 SP3 on a Win2k3 box with 8 GB ram and 4 CPUs. The only thing running on this server is SQL, and no other processes are significant in size. PROBLEM: The SQL server is running only in virtual memory and will not switch to physical memory. This can be seen in the task manager after adding the virtual memory column. HELP!!!!!
I've been searching for an hour and didn't find an answer to this one. Running a Quad Xeon 550 system with 2GB Physical RAM and a 2GB pagefile, with SQL 7 SP4 on NT4 Enterprise. According to Task Manager, as of this moment, sqlserver.exe is using 1590220K of RAM. I have the VM Size column up, and it is at 1586092K of RAM. Now, to me that says nearly ALL of the RAM that SQL is using, is Virtual Memory. That seems horribly inefficient (and, I'm thinking, perhaps the reason why sqlservr.exe causes anywhere from 50 - 400 Page Faults / sec when it gets busy). Can someone add some wisdom here and explain what is going on? Wouldn't it be best for SQL to use physical RAM? Can I force it to? Thanks
Can someone explain in lay man terms, what does SQL do with virtual memory and what does it do with physical memory? what info is contained in these memory? Is Virtual memory always on disk ? Btw, whats the difference between the 2 ? Thanks
Greetings All, I have an operation that involves the use of a cursor. This cursor is looping over a table that has about 20,000 rows. If I run this operation when SQL server is just started and total virtual memory used by SQL is low the operation takes about 3 minutes. If I wait and do some other work which causes SQL server to take up about 1.2 Gb of Virtual memory, 800MB of my 1Gb physical RAM and then run my cursor operattion it will take about 5 hours? Can anyone explain to me the relationship between virtual memory and cursor performance? Or, if there is no relationshiop what is the best way to see why the cursor operation takes 3 minutes one day and 5 hours the next day. The machine I am using is exclusive to me and I am not running anything else on it outside of Outlook, Sql Server, and internet explorer? Any and all help would be greatly appreciated. TFD