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/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_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/techinf...stration/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[vbcol=seagreen]
>Disk Monitoring
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:1080101c43fc0$a0384710$a101280a@.phx.gbl...
on
>
>.
>