Browse by Tags

Sorry, but there are no more tags available to filter with.

how can i get some performance statistics on my stored procedures in sql2005?

select case when dbid = 32767 then 'resource' else db_name(dbid) end [db_name] , object_schema_name(objectid,dbid) [schema_name] , object_name(objectid,dbid) [object_name] , sum(usecounts) [executions] , max(max_execution_time) [last_execution_time] , sum(total_logical_reads) [total_logical_reads...

Posted to roy ashbrook (Weblog) by royashbrook on 03-21-2008
SQL Server 2005 Emergency Diagnostic and Performance Queries

Great useful base diag scripts! Snipped from http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!893.entry -- SQL Server 2005 Emergency Diagnostic and Performance Queries -- Glenn Berry 3-17-2008 -- Step 1 - Check Task Manager. Are all CPUs above 90-95% for an extended period of...

Posted to roy ashbrook (Weblog) by royashbrook on 03-21-2008
how can i find when a stored procedure was last executed in sql 2005?

select top 10 t.text , s.last_execution_time , * from sys.dm_exec_query_stats s cross apply sys.dm_exec_sql_text(s.sql_handle) t where t.objectid is not null and text like '%procname%' order by s.last_execution_time desc obviously replace procname with the procname you want to find. you might...

Posted to roy ashbrook (Weblog) by royashbrook on 03-21-2008
enable clr procs on sql2005

EXEC sp_configure @configname = 'Show Advanced Options', @configvalue = 1 RECONFIGURE WITH OVERRIDE GO EXEC sp_configure @configname = 'clr enabled', @configvalue = 1 RECONFIGURE WITH OVERRIDE GO EXEC sp_configure go

Posted to roy ashbrook (Weblog) by royashbrook on 03-19-2008

Page 1 of 1 (4 items)

Drowning In Technical Debt

Browse by Tags

how can i get some performance statistics on my stored procedures in sql2005?

SQL Server 2005 Emergency Diagnostic and Performance Queries

how can i find when a stored procedure was last executed in sql 2005?

enable clr procs on sql2005