Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Performance monitoring from client Expand / Collapse
Author
Message
Posted Sunday, October 04, 2009 10:00 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 14, 2010 6:06 AM
Points: 76, Visits: 199
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
Post #797649
Posted Monday, October 05, 2009 2:52 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, March 30, 2013 6:06 AM
Points: 532, Visits: 224
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
Post #797720
Posted Monday, October 05, 2009 2:57 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:43 AM
Points: 2,723, Visits: 1,090
true but that is only a snapshot at that time.

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #797721
Posted Monday, October 05, 2009 3:00 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:43 AM
Points: 2,723, Visits: 1,090
although you can use profiler as that is a client tool

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #797723
Posted Monday, October 05, 2009 9:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:30 PM
Points: 14,802, Visits: 27,275
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #798007
Posted Monday, October 05, 2009 9:50 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 2:26 PM
Points: 386, Visits: 626
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
Post #798016
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse