Saturday, February 25, 2012

Monitor

Is there a way to find running queries and it's details on
a particular db....
I need executin time,CPU time etc...Try Profiler.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message news:1080101c43fc0$a0384710$a101280a@.
phx.gbl...
> Is there a way to find running queries and it's details on
> a particular db....
> I need executin time,CPU time etc...|||As Tibor points out Profiler is the correct tool for what you ask but here
are some links that may be of interest:
http://www.microsoft.com/sql/techin.../perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c...mance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
on_24u1.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
on_24u1.asp
Disk Monitoring
Andrew J. Kelly
SQL Server MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:1080101c43fc0$a0384710$a101280a@.phx
.gbl...
> Is there a way to find running queries and it's details on
> a particular db....
> I need executin time,CPU time etc...|||Tnaks all...
>--Original Message--
>As Tibor points out Profiler is the correct tool for what
you ask but here
>are some links that may be of interest:
>
>http://www.microsoft.com/sql/techin...istration/2000/
perftuning.asp
>Performance WP's
>http://www.swynk.com/friends/vandenberg/perfmonitor.asp
Perfmon counters
>http://www.sql-server-
performance.com/sql_server_performance_audit.asp
>Hardware Performance CheckList
>http://www.sql-server-
performance.com/best_sql_server_performance_tips.asp
>SQL 2000 Performance tuning tips
>http://www.support.microsoft.com/?id=q224587
Troubleshooting App
>Performance
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_perfmon_24u1.asp
>Disk Monitoring
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
><anonymous@.discussions.microsoft.com> wrote in message
> news:1080101c43fc0$a0384710$a101280a@.phx
.gbl...
on[vbcol=seagreen]
>
>.
>

No comments:

Post a Comment