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 |
|
BadBoy House
Starting Member
41 Posts |
 Posted - 2012-09-07 : 11:18:15
|
| We have a member server running Windows Server 2008 32-bit and SQL Server 2008 Standard 32-bit. Server has max 4GB memory for 32-bit.I would like to monitor the performance of SQL (which is the only application that runs on the server) - from a memory and say bottleneck point of view.RAM is maxed out most of the time - used primarily be SQL - but I do understand that SQL should use up all of the available RAM and release as necessary.What is the best way to monitor SQL in terms of performance? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-09-07 : 12:03:12
|
| To know if you are having a performance problem, you need to run a trace and see if the response time for the queries is acceptable. To see if you have any hardware bottlenecks, you can run Performance Monitor. For memory, be sure to watch the Page Life Expectancy counter. You want a high number. I can't give you a number though as it's dependent upon your system and what you have going on. Our servers with 48GB or more have values in the thousands. I've seen higher than 50000. Your small server probably won't see values this high, but that doesn't mean you have a problem. The value will plummet during certain operations such as updating statistics, rebuilding indexes, high reads, and anything else that could wipe out the buffer cache.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
How best to monitor SQL Server performance etc?