SQL Server Performance Forum – Threads Archive

Checklist

I was wondering, if there is a standard checklist tasks to be perform on a post SQL Server installation? I.E, Setup mail profile, create operator so on…. Appreciated if someone please share anything related to this. Many thanks,
Cali

Post installation checklist like mail profile setup and creating operators and alerts depends on the company interanal policy… http://www.sqlservercentral.com/columnists/rpearl/installingandupgradingtosqlserver2005.asp
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1188576,00.html
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thanks for the answer. The example i listed came in mind. But i was looking more generic tasks, which needs to be checked upon installation by DBA’s? Is there anything microsoft recommends upon completion of sql installaton software? Thanks,

KBAhttp://support.microsoft.com/kb/319942 to determin configuration.
Additionallyhttp://www.sql-server-performance.com/sql_server_performance_audit5.asp for the performance checklist. There isn’t anything specific stating this is what a DBA must check or perform the daily checks within their environment. Edgewood solutions has come up with this tip:http://mssqltips.com/tip.asp?tip=1240 and also refer to the responsibilities for a DBAhttp://sqlserver-qa.net/blogs/tools/archive/2007/06/17/dba-role-in-question.aspx too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Thanks for the answer Satya. I will look into it. Thanks again,

You pretty much learn to make up your own check lists from your journal/notes. You have setup checklists, migration checklists, integration checklists, etc. The checklists can change with versions and SP’s/fixes. It is easy to make up a "toolkit" to go on a DVD or laptop with the applications, utilities, Excel spreadsheet checklists, SPROCs, and scripts – you use regularily. If you have to doc a procedure for a clients, good checklists can save you a lot of time. Look for best practices in MS Press books and other sites/books – that is a good place to start.

For such best practices related information I would rather go to non Microsoft based resources, as they have generic information with less details [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</center>

It used to be the case that Microsoft dished out pretty poor information, but not anymore especially in the case of SQL 2005. 95% of the information on this website (and other MS SQL forums) is in the BOL or MS Press resources, going to a generic source often means you are getting a dummied down version of that info with some guys opinion attached. It is fine when the opinion is well founded or there is relevent, practical advice included – but it is still supplemental information to what is covered by Microsoft. Understanding the details is the difference between a poor analyst/DBA and a good one – and those same details come up over and over again…

]]>