-
StatPress TopPosts
Recent Posts
Recent Comments
- admin on Stored Procedure to Sequentially Run SQL Agent Jobs
- admin on A Busy/Accidental DBA’s Guide to Managing VLFs
- How many temp database files ? | nguyennp's blog on Script to Create A TempDB File Per Processor
- georg9 on Stored Procedure to Sequentially Run SQL Agent Jobs
- Tony Santangelo on A Busy/Accidental DBA’s Guide to Managing VLFs
Archives
Categories
Meta
Tag Archives: SSC
Where Do I Start with PowerShell?
This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend a bunch of time searching for different sites I threw the question out to the SQL Community on Twitter via #SqlHelp. The response was so overwhelming that I decided I at owed it to the SQL Community to get it all written down. Continue reading
How Can I Tell if SQL Agent is Running via SQL?
Today’s post is a continuation in my on-going effort to document all of the scripts I use to manage my environment. To date it has been a great exercise both in getting things written down and in getting feedback from others on better ways I could be doing things. To that end, here is a stored procedure that I use to tell if SQL Agent is running before trying to start a job programmatically. Continue reading
What is a Good Way to Get the SQL Server Log Directory?
The script for today is one that I use in all of my job creation scripts as well as a script I have to go back and clean up job output file paths. It gets the location of master on a SQL 2005 or SQL 2008 server, using that to find the Log directory. Continue reading
What is a Good Way to Quickly Disable SQL Agent Job Schedules?
This script has 2 major parts, disable the job schedules then notify SQL Agent of the change. Continue reading
Whats a Good Rule for Max Degree of Parallelism?
I am one of those people that believes that believes that anything worth doing is worth having a script to do it. Setting the Max Degree of Parallelism is no exception. In this post I will go through the script I use as well as the metrics I watch to make sure the setting is correct. Continue reading
Posted in Utilities
Tagged CXPACKET, Max Degree of Parallelism, MAXDOP, NUMA, SOS_SCHEDULER_YIELD, sp_configure, SSC, sys.dm_os_sys_info
5 Comments
How Do I Find SSIS Packages that Exist in Multiple Folders?
A script to find duplicate packages deployed to different folders on the same server. Continue reading
How Do I Kill All Sessions from a Windows Group?
The stored procedure I am posting today will kill all sessions for users that are members of a given domain group. I use this stored procedure to keep ad-hoc (write down Access) users out of the way of nightly builds on my data warehouse. Continue reading
T-SQL Tuesday #005 – Self Service Performance Information
My T-SQL Tuesday #005 entry allows selected users of a server to see what is going on with it and react accordingly, freeing members of the DBA team from constant questions about why the server is running slow. Admittedly it does often just lead to more informed complaints but at least the time to resolution is quicker. Continue reading
How Can I Tell if a Windows Login has Rights to My Server?
This is a great stored procedure to use for things like server dashboards where you only want people to see the dashboard for servers that they have access to without granting them all the rights that would go with the dashboard. Continue reading
Script to Create A TempDB File Per Processor
To satisfy my need to be lazy and protect me from myself I have written a script to add a TempDB file per processor. Continue reading