What happens when a SQL Server instance is restarted

A very interesting question popped up today: what happens when a SQL Server instance is restarted?

 

When an instance of SQL Server is shutdown (i.e. on the way to be restarted) what happens is:

all databases have checkpoints
all SQL Server Agent jobs are terminated and the Agent is shut down
all database files are released to the OS,

Continue reading […] What happens when a SQL Server instance is restarted […]

May 25th, 2011 | Tags: , , , , , , , , , , , | Category: Memory, Performance audit, SQL Server Architecture, SQL Server metadata | Comments are closed

 

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 […]

May 13th, 2011 | Tags: , , , , , , | Category: Decommissioning, SQL Server Architecture | One comment - (Comments are closed)