A good sql query.

Thanks

It is a good article. I always run profiler or sqldiag locally because of permance concern.

By the way, your script makes me recall the "sp_sysmon" procedure in Sybase.

😀

Just ran your modified script. It works for me and the output is neat too.

Thank you for your work,

Thank you, both.

I learned something and appreciate your hekp.

The following is my SQL query.

SELECT CREATE_DATE,

SUM(CASE WHEN LUN_NAME = 'LUN1' THEN LUN_VALUE ELSE 0 END) AS LUN1,

SUM(CASE WHEN LUN_NAME = 'LUN2'...

If you just want to run some SQL queries, please check Microsoft web site, "SQL Server Best Practices".

http://technet.microsoft.com/en-ca/sqlserver/bb331794.aspx

SQL Server Best Practices Toolbox

Scripts and Tools for Performance Tuning and...

If your environment is MS SQL 2005 + SP2, the best choice is SQL Server 2005 Performance Dashboard. It is a free download software.

http://www.sql-server-performance.com/articles/per/bm_performance_dashboard_2005_p1.aspx

For my case, after I kill user connections by using this kind of stored procedure, our application re-connects to database right away. I believe that it is the good choice...

Last week, when we installed SQL Server 2000 on Windows 2003, we got the same problem. Please look at the Microsoft web link below first.

http://support.microsoft.com/default.aspx?scid=kb;en-us;319349

But we didn't follow...

Try to use "DBCC Log(DB_Name)" to see what is in the log.