Tag Archives: SQL Scripts

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

How to control windows services from SQL Server?

Posted on March 19, 2013 by uday arumilli

How to control windows services from SQL Server? For a SQL Server DBA there are scenarios where he/she needs to deal with Windows services from SQL Server when there is no direct access to Windows server and only have access … Continue reading →

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

Script all Primary Keys, Foreign Keys in a SQL Server using T-SQL

Posted on October 26, 2012 by uday arumilli

Script all Primary Keys, Foreign Keys in a SQL Server using T-SQL Find the relationships between tables in sql server Get Primary Key and Foreign Key details using T-SQL   How to find all related tables of a given table? … Continue reading →

Posted in SQL Development, SQL Scripts | Tagged , , , , , , | Leave a comment