Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
helpme
Posting Yak Master
141 Posts |
 Posted - 2010-06-02 : 11:42:02
|
| We have a maintenance plan that runs weekly to rebuild indexes. It used to finish, but now we usually wind up stopping it after it runs several hours. The only message I see in the logs is 'A significatn part of the sql server process memory has been paged out. This may result in a performance degradation'. We have several tables in multiple databases, but most are pretty small. The total size of all databases is about 5g. Are we doing something wrong, or are we asking too much of the server? (virtual server running sql 2008, windows 2008, about 2g of memory). |
|
|
jimmycjen
Starting Member
15 Posts |
Posted - 2010-06-08 : 16:03:38
|
| There could be many reasons. Start with hardware (1) how many cpus and what are their speed (2) the data resides on a single hard drive or RAID, and what's drive speed ? (3) OS running 32-bit or 64-bit ? If 64-bit, you should add more RAM. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
maintenance plan question