Tag Archives: DBA

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

Posted on March 20, 2013 by uday arumilli

 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

Automate database restore procedure SQL Server

Posted on October 22, 2012 by uday arumilli

Automate database restore procedure SQL Server Make sure that the stored procedure “[dbo].[DB_Restore]” is available at Target Instance master database.  Connect to target server instance and open a new query window from SSMS Why Database Restore Automation? It reduce the … Continue reading →

Posted in SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , , , , , , | 4 Comments