Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: March 2010

Making Sense of Replication Errors in Replication Monitor

Making Sense of Replication Errors in Replication Monitor
 
If you've ever had to deal with errors in Replication Monitor, your first experiences with it probably involved confusion. Sometimes the error messages are too generic and do not help you find a resolution.
 
Replication Monitor also tells you the…

Read more

Measuring Transactional Replication Latency Without Tracer Tokens

Measuring Transactional Replication Latency Without Tracer Tokens
 
SQL Server 2005 introduced Tracer Tokens (SQL 2005 | SQL 2008), a new methodology for programmatically measuring replication latency in transactional replication. To measure latency with a tracer token, you simply insert a tracer token at the publisher. The replication…

Read more

Twas the Night Before the MCM ...

T'was the Night Before the MCM ...

SQL Server MCM starts tomorrow. My wife thinks it's cute that I'm excited. The location is a place that I know well. It's in building 40, and I used to work in building 22 which is right down the hill. Meeting space is… Read more

Finding Date Ranges for Calculating Statistics

Finding Date Ranges for Calculating Statistics

I received the following question from a fellow DBA:

I need your input to derive the reliability of one of the tool I am currently working …

 

I have table which has outagedate column with dates like below

WeeklyOutageDate
2009-12-05 04:21:00:000
2009-12-06 08:22:00:000

Read more

Top 6 Myths of Transaction Logs

Top 6 Myths of Transaction Logs
 
I think there is a lot of misunderstanding concerning database transaction logs in SQL Server. I had intended to write this as the top 5 myths, but I wasn't able to narrow the list down that far.
 
Myth #6: I added additional log…

Read more

T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?

T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?

This blog entry is participating in T-SQL Tuesday #004, hosted this month by Mike Walsh. You are invited to visit his blog to join the party and read more blogs participating in this month’s theme: IO. 

The question was raised… Read more

SQL LiteSpeed Error: XML returned from Engine was invalid

 SQL LiteSpeed Error: XML returned from Engine was invalid

This is a very common error returned from SQL LiteSpeed. So what does it actually mean? What is the root cause?
 
What does it mean?
It means exactly what you think it means. When you first see it, you…

Read more

Breaking Down TempDB Contention

Breaking Down TempDB Contention 

What is tempDB contention?
 
From the outside looking in, tempDB contention may look like any other blocking. There are two types of contention that tends to plague tempDB's, especially when the tempDB is not configured to best practices (multiple, equally sized data files, located…

Read more