SQL Server Blogs

SqlServerWriter missing when VSSadmin list writers command is run

In this blog, I will discuss about what to do when : 1. we run Vssadmin list writers command and...

Date: 08/01/2011

Troubleshoot high CPU issue without using profile traces

The scope of these issues is very wide but I would discuss about the approach which I follow to...

Date: 07/23/2011

In SQL server, How to see the standby file path when we restore the database in standby mode:

I was answering to the questions on Social.msdn.microsoft.com forum site, Someone posted the...

Date: 07/20/2011

Perfmon counters missing for newly added database in sql server 2005

Hello Everyone! Recently I was working on a scenario in which we were not able to see any perfmon...

Date: 03/15/2011

Data Capturing and Analysis using SQL Server 2008 Activity Monitor and SQL DMV’s

In this blog, I will be sharing a unique instance of data capturing and analysis using SQL Activity...

Date: 11/23/2010

SQL Server encounters memory pressure and generate 701 Error due to incorrect configuration of Service Broker

Here is one of the rare scenario on SQL Server memory issue (701 error) caused due service broker...

Date: 11/23/2010