SQL Server: Script to find CPU Pressure using Signal Wait Time

In this post, I am sharing a SQL Script to find CPU Pressure using SignalwaitTime wait type in SQL Server. Sometimes, Running queries are waiting for resources and SQL Server records related wait type. We can analyze wait stats and take decision accordingly. In this script, I am showing one Signalwait stats for measuring the […]

November 13, 2015 SQL Server, SQL Server DBA Script

November 12, 2015

PostgreSQL: Important Parameters to enable Log for all Queries

November 11, 2015

SQL Server: Script to find total Row Count of All Tables in a Database

November 10, 2015

PostgreSQL: Function to truncate all Tables created by Particular User

November 9, 2015

SQL Server: Error 701 There is insufficient system memory to run this query

November 8, 2015

PostgreSQL: SELECT Last Inserted ID or Sequence Value

November 7, 2015

SQL Server: Script to find Missing Indexes

November 6, 2015

SQL Server: Monitor and Manage Database Corruption

November 5, 2015

SQL Server: A Different command to check Basic Security Audit

November 4, 2015

SQL Server: Script to find the Location of Database Backup Files

Older posts Newer posts

About Me!