Tag Archives: Production Issues

Monitor CPU utilization, I/O Usage and Memory Usage in Sql Server

 Monitor CPU utilization, I/O Usage and Memory Usage in Sql Server CPU Usage, I/O Usage and Memory Usage of database   Database level / Database wise CPU, memory and I/O usage As part of DBA’s daily checklist, we need to … Continue reading

Posted in Performance Tuning, SQL Server DBA | Tagged , , , , , , , , , , , , , | 1 Comment

The sql server service failed to start

The sql server service failed to start I have got a request to install SQL Server 2005 Standard Edition with SP4. While installing database services it suddenly failed by throwing a pop – up. The error message : “The SQL … Continue reading

Posted in SQL Server DBA | Tagged , , , , , , , , , , | Leave a comment

How to rebuild Master Database in SQL Server

How to rebuild Master Database in SQL Server We recently resolved a request from a client that he is not able to access a SQL machine. We have logged into the sql box and we cam to know that the … Continue reading

Posted in SQL Scripts, SQL Server DBA | Tagged , , , , , , | Leave a comment