Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

<< Newer    Items 61 to 80 of 3033    Older >>
 

what tables and indexes are using the most memory in the buffer cache

Tells you what tables and indexes are using the most memory in the buffer cache  Read more...
By Patrick Akhamie 2014/05/27 | Source: SQLServerCentral.com | Category: buffer cache
Rating: |  Discuss |   Briefcase | 2,033 reads

do we have local memory pressure

The script will help you find out if you have memory pressure on your server. See the explanation below for more.  Read more...
By Patrick Akhamie 2014/06/05 | Source: SQLServerCentral.com | Category: buffer pool
Rating: (not yet rated) |  Discuss |   Briefcase | 1,544 reads

Find Buffer Pool usage by database

Find out how much of your buffer pool each database is using and identify the hardest hitting databases.  Read more...
By Patrick Akhamie 2014/06/10 | Source: SQLServerCentral.com | Category: buffer pool
Rating: |  Discuss |   Briefcase | 875 reads

Find Top 10 consumers of memory from Buffer Pool

The query returns information about the Top 10 consumers of memory from Buffer Pool  Read more...
By Patrick Akhamie 2014/06/12 | Source: SQLServerCentral.com | Category: buffer pool
Rating: |  Discuss |   Briefcase | 1,185 reads

CPU Usage by Database

A compilation of 3 scripts to show detailed CPU usage data by database.  Read more...
By Patrick Akhamie 2014/07/08 | Source: SQLServerCentral.com | Category: cpu usage data
Rating: |  Discuss |   Briefcase | 2,412 reads

Query current runtime data for the resource pools and workload groups

The Query will return the current runtime data for the resource pools and workload groups  Read more...
By Patrick Akhamie 2014/06/19 | Source: SQLServerCentral.com | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 436 reads

Query to find what requests are running in the classifier

The Query will return results for all requests running in the resource governor classifier  Read more...
By Patrick Akhamie 2014/05/20 | Source: SQLServerCentral.com | Category: resource governor
Rating: |  Discuss |   Briefcase | 523 reads

Query to find all sessions in each group

The Query will return results for all sessions in each resource governor group  Read more...
By Patrick Akhamie 2014/07/01 | Source: SQLServerCentral.com | Category: resource governor
Rating: |  Discuss |   Briefcase | 900 reads

Query to find all requests in each group

The query will return all requests in each resource governor group  Read more...
By Patrick Akhamie 2014/04/30 | Source: SQLServerCentral.com | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 87 reads

Email the Auto-growth events that have occurred in the last 24 hours

-- This script will email DBA if a auto-grow event occurred in the last day -- Written by: Patrick Akhamie -- Date: 10/06/2011  Read more...
By Patrick Akhamie 2014/09/11 | Source: SQLServerCentral.com | Category: autogrowth
Rating: |  Discuss |   Briefcase | 1,825 reads

Script to Get Total of database sizes in MB nd GB

Displays the log size and db size for all databases on an instance. Good for a CMS too.  Read more...
By Patrick Akhamie 2014/04/30 | Source: SQLServerCentral.com | Category: db size
Rating: |  Discuss |   Briefcase | 617 reads

Check SQL Server Services Status and send email

--The script can be used in a job or run ad-hoc to inform the dba group of the status of sql services on your servers.  Read more...
By Patrick Akhamie 2014/04/30 | Source: SQLServerCentral.com | Category: sql services
Rating: (not yet rated) |  Discuss |   Briefcase | 400 reads

Get SQL Cluster Information (T-SQL)

Get info about clusters to include active and passive nodes as well as disk members for SQL 2005/2008/2008R2  Read more...
By Patrick Akhamie 2014/04/30 | Source: SQLServerCentral.com | Category: sql cluster
Rating: |  Discuss |   Briefcase | 334 reads

Enable and configure DB mail using T-SQL

Use this to enable and setup database mail in sql server 2005/2008  Read more...
By Patrick Akhamie 2014/06/24 | Source: SQLServerCentral.com | Category: dbmail
Rating: |  Discuss |   Briefcase | 1,240 reads

Script to Detach All User Databases

The script will automatically detach all databases. Please run sp_helpdb to find out the location of all data and log files before using the script.  Read more...
By Patrick Akhamie 2014/06/26 | Source: SQLServerCentral.com | Category: detach database
Rating: (not yet rated) |  Discuss |   Briefcase | 689 reads

Find SQL Server Install Date

This is handy script which could be used to find the SQL Instance install date.   Read more...
By Patrick Akhamie 2014/07/10 | Source: SQLServerCentral.com | Category: documentation
Rating: |  Discuss |   Briefcase | 1,077 reads

Fix orphaned users after restoring database to another server

Find and fix orphan users after doing a database restore. It uses cursors but they are pretty minimally intrusive.  Read more...
By Patrick Akhamie 2014/07/17 | Source: SQLServerCentral.com | Category: orphan users
Rating: |  Discuss |   Briefcase | 1,540 reads

Replication Monitor Script

The script shows great detail about the topoogy of replication as well as the status and undistributed commands as well as other neat details about the architecture of the replication including all publications and subscriptions.  Read more...
By Patrick Akhamie 2014/07/03 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 854 reads

List all the fields of a table with its properties + PK

This script returns a list of all the fields of a table with it properties, primary keys and user defined types.  Read more...
By Joan Magnet 2014/05/23 | Source: SQLServerCentral.com | Category: table fields definition
Rating: |  Discuss |   Briefcase | 1,287 reads

script to find mirrored databases on principal or mirrored instance

The script helps you find out what databases are mirrored, their state, the partner instance and the enpoint port. Part two shows the endpoint details.  Read more...
By Patrick Akhamie 2014/05/22 | Source: SQLServerCentral.com | Category: monitor mirroring
Rating: (not yet rated) |  Discuss |   Briefcase | 474 reads
<< Newer    Items 61 to 80 of 3033    Older >>