Sign In
Troubleshooting Microsoft SQL Server
Blog is a collection of misc troubleshooting tips collected while supporting Microsoft SQL Server 2000, 2005, and 2008. Specialty area covered is SQL Server Data Replication including Transactional Replication, Merge Replication, Change Data Capture, and
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
18452 18456 ANONYMOUS
Best Practices
DBA
IsDomainNetworkTopOfBindings
replication filestream
skip invalid transaction replication LSN
sp_cycle_agent_errorlog
sp_cycle_errorlog
sp_readerrorlog
sql 2005 2008 linked server
SQL DMV
SQL Server Performance Dashboard
STATISTICS FULLSCAN
TokenAndPermUserStore
Archive
Archives
January 2011
(2)
August 2010
(1)
June 2010
(1)
May 2010
(1)
April 2010
(1)
March 2010
(6)
February 2010
(4)
January 2010
(9)
December 2009
(3)
September 2009
(2)
July 2009
(2)
May 2009
(2)
April 2009
(1)
March 2009
(1)
February 2009
(1)
December 2008
(1)
August 2008
(1)
June 2008
(5)
June 2006
(3)
June, 2008
MSDN Blogs
>
Troubleshooting Microsoft SQL Server
>
June, 2008
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Troubleshooting Microsoft SQL Server
Troubleshooting Transactional Replication Distribution Agent Latency
Posted
over 4 years ago
by
Chris Skorlinski [MSFT]
0
Comments
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...
Troubleshooting Microsoft SQL Server
Query to return list of Dynamic Management Views
Posted
over 4 years ago
by
Chris Skorlinski [MSFT]
1
Comments
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' )...
Troubleshooting Microsoft SQL Server
Performance Dashboard error "Difference of two datetime values caused an overflow at runtime"
Posted
over 4 years ago
by
Chris Skorlinski [MSFT]
1
Comments
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....
Troubleshooting Microsoft SQL Server
I/O requests taking longer than 15 seconds to complete on file
Posted
over 4 years ago
by
Chris Skorlinski [MSFT]
2
Comments
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...
Troubleshooting Microsoft SQL Server
Script to purge TokenAndPermUserStore
Posted
over 4 years ago
by
Chris Skorlinski [MSFT]
0
Comments
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...
Page 1 of 1 (5 items)