How to check the Cluster Size for a drive or Allocation unit size for a drive?

Posted by Sqltimes
On February 23, 2013
0 Comments

As documented on BoL, the recommended cluster size (Allocation Unit Size) for Sql Server files is 64K. For Windows drive, the recommended (or the default) is 4K. Let’s say you log into a new server and all of this is already configured, how do you query or figure out what was the allocated unit size […]

Posted by Sqltimes
On February 16, 2013
0 Comments

There is a quick and easy way to set up Aliases for long and boring Sql Server Instance Names. Let’s say, I have a Sql Server Instance (name:Sandbox) on a machine with some long name like HPWPSVR3009DELL. Now to connect to this Sql Instance, through SSMS, you use HPWPSVR3009DELL\Sandbox. This is too long and too […]

Posted by Sqltimes
On February 10, 2013
0 Comments

When you restart Sql Server, it goes through several steps to make sure that the instance is up and running including the user databases. It is important to make sure that the data that was committed before restart is still intact. Rollback and roll forward are some of the steps it goes through for each […]

Posted by Sqltimes
On February 8, 2013
0 Comments

Recently, we had a scheduled down time for a production server to perform some maintenance tasks. One of them was to move the tempdb to a dedicated drive of its own. This is was the first step and then implement a bunch of optimization steps. But guess what !! There was a bug (mistake) in […]

Posted by Sqltimes
On February 3, 2013
0 Comments

When Sql Server is restarted, along with a lot of other things, a new Sql Server Error Log file is created in its default location (…\MSSQL10.MSSQLSERVER\MSSQL\Log\). When you open that location, you’ll see abunch of ERRORLOG files with names like: ERRORLOG ERRORLOG.1 ERRORLOG.2 … A new file is created after every restart with the name […]

How to check the Cluster Size for a drive or Allocation unit size for a drive?

Sql Server Aliases

Sql Server Start up Steps

Sql Server does not start

Recycle Sql Server Error Logs (or create new sql server error logs)