Tag Archives: services

When was SQL Server restarted?

Over the weekend, I interacted with some of the “wanna be” DBAs. During the interaction I checked with them how they would find when was the SQL Server instance restarted? Everyone had a different approach to find out the information. Here are … Continue reading

Posted in scripts, SQLServerPedia Syndication | Tagged , , , , , | 7 Comments

Configuring SQL Server to use Windows Large-Page allocations

One of the Change Controls implemented today had inspired me to write this post. The Change Control was to enable Trace flag 834 on a SQL Server 2005 instance running on Windows 2008 Server (64 bit). As explained in this article, … Continue reading

Posted in Configure, services, SQLServerPedia Syndication | Tagged , , | 7 Comments