June 18, 2008 at 7:50 am
Hi All,
Could anyone tell me what is the basic requirement to see the database and sql server performance. And how to analysis to see the performance?
With regards,
Sunil
June 18, 2008 at 7:56 am
what monitoring tool(s) are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 8:47 am
Regarding database u need to monitor database growth by checking data and the log files how much its growth,especially log files increases as it logs all the operations.Monitor that for database performance and check the db size also.
SQl performance
SQl performance can be monitored through
1)Task manager-their check for cpu utilization which should not be greater than 70 %
2)System monitor
3)Performance monitor options.Depend on the situation we nee to check performance
June 18, 2008 at 9:08 am
You'll want to look at performance monitor counters over a period of time to get an idea of what your server's up to and where the bottlenecks are. There are plenty of tools out there that you can use to gather this data (most cost $$): Spotlight on SQL Server[/url], SQLSentry Performance Advisor[/url], SQL Diagnostic Monitor, and Microsoft's SQLH2 are some of the more well known products.
Regardless of what you use to monitor things, you need to know what to monitor. Kevin Kline put together a 4 part webcast on Perfmon Counters for the SQL DBA over on SearchSQLServer.com. Do a search for "SQL Performance Monitors" on Google and you'll get a gazillion results as well.
Once you have some idea of where your performance issue are you can use the DMVs in SQL to identify queries that might need to be tuned, missing indexes, etc. This assumes your issues are inside the DB and not at the server level (e.g. available memory).
June 18, 2008 at 3:38 pm
if you plan on using perfom there are a set of key counters to look at, what do you plan to use?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 19, 2008 at 7:11 am
To get access to the performance counters, if you're not a member of the local administrators group, you'll have to be a member of the Performance Monitor Users local group to see the counters in real time. To set up counter logging, you'll have to be a member of the Perfomance Log Users group. This will give you access to the performance counters that you'd see in Perfmon. This includes the SQL Server counters.
This is with respect to Windows Server 2003. If you're still using Windows 2000 Server, you'll have to research which registry permissions you'll have to change.
However, as asked, what are you trying to monitor? That really determines your method and your analysis.
K. Brian Kelley
@kbriankelley
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply