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 |
|
shebert
Yak Posting Veteran
85 Posts |
 Posted - 2009-10-12 : 15:26:57
|
| Hello Allthe USE AWE to allocate memory was not checked on the server properties.the server has been experienceing high 100% disk que andbuffer cache hit ratio down to 86since I check the AWE box it seems to have gotten better, but there were also over 200 sleeping connection that I killed.so I am not sure what made the difference.any thoughtsSteve |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-10-14 : 15:48:53
|
| Give us your server specs. |
 |
|
|
shebert
Yak Posting Veteran
85 Posts |
Posted - 2009-10-16 : 00:13:56
|
| Server specs? |
|
|
|
shebert
Yak Posting Veteran
85 Posts |
Posted - 2009-10-16 : 10:29:37
|
| I read that you need to enable lock pages in Memory for AWE. but this could also have bad results on server.the server has 3.5 gig of Ramserver 2003 SP2sql 2005 9.0.3042intel xeon 3ghz 4 processorsI had also added update statistic to the maint. plan that backups up nightly. added some indexs. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-10-17 : 11:04:49
|
| You need to increase the memory. |
|
|
|
|
|
|
Performance is SQL2005