Tag: Homework
-
Monitor SqlServer Stored Proc execution time
I have had the task to made something to monitor what stored procedure,in Sql Server,in most used. The problem that I have had is that the host_name is easily changed by putting,in the connection string WSID (see http://msdn.microsoft.com/en-us/library/ms178598.aspx ) The code is for sql server 2005 and I have not realized without the help of…