What happens when a SQL Server instance is restarted

RIL_button( “http://sqlconcept.com/2011/05/25/what-happens-when-a-sql-server-instance-is-restarted/”, “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

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
Work on itWell, now...OKGoodGood job! (8 votes, average: 4.88 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

The SQL Server metadata concept

RIL_button( “http://sqlconcept.com/2011/04/27/the-sql-server-metadata-concept/”, “The SQL Server metadata concept” );

… the data describing the data describing the data described described data described by data… (and so on)

 

The charm of SQL Server is that it comes with a good set of metadata. Even in SQL 2000 there were plenty of system objects containing data about the instance and

Continue reading [...] The SQL Server metadata concept [...]

April 27th, 2011 | Tags: , , , , , , , , , | Category: SQL Server Architecture, SQL Server metadata | Comments are closed
Work on itWell, now...OKGoodGood job! (1 votes, average: 1.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...