How to query currently running SQL Server Agent jobs

Today I went on a quest to discover a way to list all currently running SQL Server Agent jobs. As every other quest, this one also started with Google-ing.

Within 2 minutes I found this great post by Brent Ozar on SQLServerPedia. Why is this post so great? It is so great because Brent figured

Continue reading […] How to query currently running SQL Server Agent jobs […]

 

How to decommission database or SQL Server instance

How to decommission a database

Before decommissioning a database, try to find out which application the database is related to. Either talk to the application owner or run Profiler for some time and check if anyone is using the database.

Here are some steps to take:

Check if the database is in use.

run Profiler, sp_who2, cached plans, index

Continue reading […] How to decommission database or SQL Server instance […]