Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Processes Rss

   Items 1 to 17 of 17   
 

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2016/01/06 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 11,721 reads

Kill all USer Sessions before starting to restore a Database

If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script  Read more...
By S M 2015/08/05 | Source: SQLServerCentral.com | Category: sql restore
Rating: |  Discuss |   Briefcase | 1,645 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2016/01/06 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 11,721 reads

Data Mining: Part 15 Processing Data Mining components with SSIS

In this lesson, we will show different components to Administer the Data Mining Models with SSIS.  Read more...
By Daniel Calbimonte 2014/08/28 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 2,587 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2016/01/06 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 11,721 reads

SQL Monitor Metric: Processes in a runnable state (scheduler query)

Use this script in SQL Monitor to determine the general load on the operating system you can get a count of the processes that are in a runnable state. This value will go up and down as various systems run on the operating system. It’s only a measure of load on the system and won’t indicate the cause of problems, but will show you pressure on the system.   Read more...
By Press Release 2013/12/03 | Source: SQL Monitor Metrics | Category: monitoring
Rating:  Rate this |   Briefcase | 3,223 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2016/01/06 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 11,721 reads

Fix SSRS Subscription Owners

Stored procedure to update SSRS Subscription owners to avoid email errors.  Read more...
Rating: |  Discuss |   Briefcase | 975 reads

Quick check SQL connection and process details with current SQL text

This script will be useful to quickly check incase of any blocking or log wait occurs  Read more...
By Venugopal Saride 2011/12/30 | Source: SQLServerCentral.com | Category: connections
Rating: |  Discuss |   Briefcase | 1,464 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2016/01/06 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 11,721 reads

Collect SQL Server/Process Information - Quickly

Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.  Read more...
By Rudy Panigas 2011/04/21 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 5,346 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2016/01/06 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 11,721 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2016/01/06 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 11,721 reads

Collect SQL Server/Process Information - Quickly

Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.  Read more...
By Rudy Panigas 2011/04/21 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 5,346 reads

Identify last statement run for a specific SQL Server session

The process to return the last query statement executed is quite straight-forward and works in all versions of Microsoft SQL Server since DMOs (dynamic management objects) were integrated into SQL Server.   Read more...
By Additional Articles 2009/07/30 | Source: MSSQLTips.com | Category: administration
Rating:  Rate this |   Briefcase | 4,274 reads

Easy and Repeatable Testing of DB Code (Stored Procs, etc.) with DbFit

Testing DB code is not fun or easy so it usually gets ignored. But now there’s a super-easy way to test using DBFit.  Read more...
By Solomon Rutzky 2008/11/13 | Source: SQLServerCentral.com | Category: testing
Rating: |  Discuss |   Briefcase | 9,760 reads

Terminate All User Processes Without Stored Procedure in SQL Server

This script kill all connections on the specified database without stored procedure.  Read more...
By andre.brunaldi 2008/09/10 | Source: SQLServerCentral.com | Category: kill
Rating: |  Discuss |   Briefcase | 254 reads
   Items 1 to 17 of 17   
 
Tags
monitoring (3)    
blocking (2)    
connections (2)    
activity (1)    
administration (1)    
agile (1)    
data (1)    
data mining (1)    
dbfit (1)    
email (1)    
enhancement (1)    
error handling (1)    
failure (1)    
fitnesse (1)    
kill (1)    
life cycle (1)    
locking (1)    
metrics (1)    
microsoft (1)    
performance monitoring (1)    
report (1)    
reporting services (ssrs) (1)    
schedulers (1)    
sp_who (1)    
sp_who2 (1)    
sql restore (1)    
sql server 2008 (1)    
subscription (1)    
testing (1)    
users (1)    
xmla (1)