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

Scripts by Patrick Akhamie

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

buffer_memory_mgt

If you ever need to find out what database is using up the most buffer pool resource, this will help. You will also get the object in the buffer for the specific database that is using up the most buffer resource. It will help when troubleshooting buffer related issues.  Read more...
By Patrick Akhamie 2014/04/22 | Source: SQLServerCentral.com | Category: buffer mgt
Rating: (not yet rated) |  Discuss |   Briefcase | 30 reads

Find Average Page Life Expectancy

I have a brief note in the query header itself  Read more...
By Patrick Akhamie 2014/04/22 | Source: SQLServerCentral.com | Category: ple
Rating: (not yet rated) |  Discuss |   Briefcase | 22 reads

Create notifications for failed jobs with one easy script

Here an easy way to setup alerts for all sql agent jobs. Typically I use this to send an email alert when a job fails. I always setup a group email address rather than individuals to make this a one-time setup.  Read more...
By Patrick Akhamie 2014/04/22 | Source: SQLServerCentral.com | Category: sql agent
Rating: (not yet rated) |  Discuss |   Briefcase | 38 reads

vlfs_Count_for_Each_Database

Here is a short code to count the VLFs in the transaction log for each database in the instance.  Read more...
By Patrick Akhamie 2014/04/21 | Source: SQLServerCentral.com | Category: transaction_log
Rating: |  Discuss |   Briefcase | 38 reads

Server_Config_Script_2012

Here's a quick query you can run across all your servers (2012) to find a wealth of information like service pack, edition, number of CPUs and RAM. Even more is available if you want to add additional SERVERPROPERTY attributes or fields from one of the DMVs.  Read more...
Rating: |  Discuss |   Briefcase | 1,361 reads
   Items 1 to 5 of 5