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...

Author: Harsh Chawla 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...

Author: Harsh Chawla 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...

Author: Harsh Chawla 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...

Author: Harsh Chawla 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...

Author: Harsh Chawla 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...

Author: Harsh Chawla Date: 11/23/2010