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 |
|
shadowmaster
Starting Member
1 Post |
 Posted - 2008-09-04 : 05:42:39
|
| Hi!I have a special problem with this server config:Windows 2003 std 64 bitSQL 2005 std 64 bit2x Xeon 5xxx series16 GB RamAfter one or two weeks of operation the user complain a decreasing SQL query performance. But the DB growth is less than 1% a week, so I assume that this problem is not caused by sub-optimal indices.After the application of some security patches to the OS the server had to be rebooted. After the reboot the users observed the "original" performance. I suspect some memory flaws somewhere in the OS or in the SQL 2005 that causes the system to slow down the database performance :-(Do you know a problem like this (which is not caused by a poorly designed db)?42 is just an answer to thousands of possible questions. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-04 : 08:21:06
|
| Looks like you had a issue with Memory paging out. |
 |
|
|
preethi
Starting Member
11 Posts |
Posted - 2008-09-04 : 23:11:58
|
| Can you tell us the size of the database?Cheers,Preethiviraj KulasinghamMCITP: DBA |
|
|
|
|
|
|
SQL slows down after some weeks