October 4, 2009 at 10:00 pm
Hi,
This is question has been asked by the interviewer , how to monitor the performance of the server from the client side?
can anybody help me
thanks
Koteswarrao
October 5, 2009 at 2:52 am
Hi,
We can use Dynamic Management Views to monitor performance
'sys.dm_os_performance_counters' This DMV makes it possible to query a view directly to capture the SQL Server counters related to the instance
Regards,
Jagadeesan
October 5, 2009 at 2:57 am
true but that is only a snapshot at that time.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 5, 2009 at 3:00 am
although you can use profiler as that is a client tool
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 5, 2009 at 9:38 am
Performance Monitor (perfmon) and dynamic management viewws (DMV's) are best. You can also browse the trace events from a server side trace on the client machine using Profiler. I would not recommend running Profiler against a production system directly. You can also look at the Activity Monitor through Management Studio, but that's just showing you the output of queries against the DMV's.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 5, 2009 at 9:50 am
you've got several options, depending on the version you've got and what tools you can install on your local desktop.
Activity Monitor, but it doesn't auto refresh in 2000, you set the refresh rate in 2005, and it is automatic and has a lot of info on 2008
DMV's and DMF's (but you need to know what they do and why you would look at them) You can execute these locally but technically they execute on the server.
Perfmon Counters (these are server side but you pull them down and agrigate them client side)
You could use Profiler (short term), but if you run Profiler too long from a client station it will hog up resources and can really degrade your server performance (trust me found out the hard way on this one). I would recommend server side trace files, and again you could pull them down locally and examine the results.
I think the big question is what do they mean on the client side, everything you pull is coming from the server and can be gathered at that end as well if you have the db tools installed.
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply