How to resolve error “system.data.sqlclient.sqlerror write on “???” failed ” observed during restore of SQL DB.
SQL Server 2008
Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.
This article helps to resolve SQL Server message – Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.
Find which SQL Server Edition is in your Production setup
Find the SQL Server Edition using simple command
How to Add a Not Null Column to an Existing Table in SQL Server
Article on how in SQL Server Not Null Column is added to an Existing Table which has millions of existing records.
Find Index Fragmentation for All Databases
This article provides queries to determine Index Fragmentation for all databases or specific database or specific table in database.
How to Troubleshoot DB Blocking and Connection issues
Are you facing SQL Server 2008 DB resource deadlock and DB connection issues? Check this article to find list of active sessions, find the number of connections established from each server/ client and total number of active connections and blocking processes.
Msg 50000, Level 16, State 1, Procedure Name: ‘XYZ’ Severity Code: 14 Error State: 1 Error Number: 2627 Error Line: 2833 Error Message: Violation of PRIMARY KEY constraint ‘PK_XYZ’.
If you are facing below error while executing the stored procedure – Msg 50000, Level 16, State 1, Procedure Name: ‘XYZ’ Severity Code: 14 Error State: 1 Error Number: 2627 Error Line:2833 Error Message: Violation of PRIMARY KEY constraint ‘PK_XYZ’. Cannot insert duplicate key in object ‘ABC.24_RPT’. This is user defined error and you need […]
100% memory usage by SQL Server 2008
One of our client reported that SQL Server is using almost 100% memory on the server. After analysis we found that what our client observed was actually designed behavior of SQL Server. When Microsoft SQL Server is started, it slowly starts using memory and after some time you may observe that whole memory is used […]
How to find Database size in SQL Server 2008 R2
There are different ways to find the DB size. The easiest way is: 1. Login to SQL Server Management Studio –> Select the DB—>Right click on Properties The popup as shown below will show the DB size- The size shown 3743.38 MB is sum of Data and Log files. Point to understand here is that […]
How to investigate 100% CPU usage problem in SQL Server 2008
If SQL Server 2008 is showing 100% CPU usage then following actions should be taken to find the cause of the problem and to rectify it. 1. Verify in Task Manager—>Processes, that Sqlserver.exe is using 99% or 100% CPU activity. 2. Invoke Activity Monitor in SQL Server Management Studio to check the processes taking most […]