Instant Initialisation

In Windows 2008
gpedit.msc --> computer configuration --> windows settings --> security settings --> local policies --> user rights assignments --> "lock pages in memory"
give sql server service account here.

align primary disk partitions

How to set primary partition of disk drives on a server
cmd --> diskpart
list disk
select disk
create partition primary align = 1024

now goto computer management --> storage
format disk with specified block (64k for compellent and 4k for ramsan)
assign drive letter and label the drive

Note: if any error message comes as like disk is write protected, then
goto disk management --> brign it online --> initialise disk

Set DB to Single/Multi User Mode

-- setting database to single user mode
ALTER DATABASE db_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE

-- setting database to multi user mode
ALTER DATABASE db_name SET MULTI_USER

SQL Server Configuration Manager - SQL Server Services - Exception

When I opened SQL Server 2008 R2 – SQL Server Configuration Manager, under "SQL Server Services" in the right hand pane had the following error "The server threw an exception. [0x80010105]"

Solution to this problem i found after doing research on internet:

Restart the "Windows Management Instrumentation" service on machine where SQL Configuration Manager is installed.

Start -> Run -> "Services.msc", scroll down to "Windows Management Instrumentation", right-click and "Restart"

Note: You may have to check with system administrator as there may be few other services dependent on this service and may be restarted as well.

Close and reopen SQL Server Configuration Manager and hopefully you'll see all SQL Server Services.