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 |
|
ddamico
Yak Posting Veteran
76 Posts |
 Posted - 2008-11-12 : 09:59:09
|
| Good day.I am working on analyzing a database server which is dedicated to the thirdparty application Orion SolarWinds. Its continually recording data. The application is running on a separate box.SQL Server 2005 Workgroup Edition (x32 OS)4.00GB RAM4 ProcessorsPage File: 5GBPage File in Use 2GBAfter doing a base line performance trace i notes the page file usage by SQL Server is continually 1% which according to blogs I am reading is bad.I guess what I am looking for is some infinite wisdom on possible solutions to reduce the high usage on the system since its becoming sluggish.1. What Performance counters? Profiler Options?2. What can be done to reduce page file usage?3. Any recommended sites to help resolve the issues?Any help would be appreciated. |
|
|
|
|
|
Page File Usage Extremely High