Blog is a collection of misc troubleshooting tips collected while supporting Microsoft SQL Server 2000 2005 and 2008 customers.
Forcus area covered include SSIS, Performance, and Replication
June 2008 - Posts
-
Here is a tip I found while troubleshooting a Distribution Agent latency problem. We were trying to see why on some days the Distribution Agent was "getting behind". We suspected it was volume related. Below are a few queries to help uncover workload Read More...
|
-
I don't always remember names of the SQL Server Dynamic Managment views. Books Online is great, but here is a simple query to get a list of DMVs SELECT * FROM sys . all_objects WHERE [name] LIKE '%dm_%' AND [type] IN ( 'V' , 'TF' , 'IF' ) AND [schema_id] Read More...
|
-
Have you tried using SQL Server Performance Dashboard? We're using this tool on SQL Server Escalation team with customers to troubleshoot real-time performance problems. It is a great way to quickly find queries with high-CPU, high-reads, waits, etc. Read More...
|
-
What does the “I/O request” error below represent? 2008-04-21 13:26:42.480 spid364 Microsoft SQL Server 2005 - 9.00.3177.00 (Intel X86) 2008-04-22 16:30:02.140 spid6s SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds Read More...
|
-
Here is a script that purge the 'TokenAndPermUserStore' every time it reaches 100MB. DECLARE @CacheSize int DECLARE @CurDate varchar ( 30 ) WHILE ( 1 = 1 ) BEGIN SET @CurDate = CONVERT ( varchar , GETDATE (), 126 ) SELECT @CacheSize = SUM ( single_pages_kb Read More...
|
