DotNetShoutout - SQL Server: Automatically Detect and Kill Long Running Processes on Production Servers : Connect SQL

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

4
Shouts

Shout it

SQL Server: Automatically Detect and Kill Long Running Processes on Production Servers : Connect SQL

published 249 days, 17 hours, 4 minutes ago posted by

lionofdezert 255 days, 23 hours, 13 minutes ago

You can not stay login on production servers all the time to detect long running query, so how to detect long running processes and kill them automatically if they are exceeding a specific amount of time. As well as sending a mail to DBA team that how a process was creating problems, so it is killed ;)

category: Data | clicked: 14 | | source: connectsql.blogspot.com | show counter code

tags:

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout