January 8, 2005 at 3:43 pm
I am doing a first time interview of a new clients database systems. Can anyone tell me if there is a white paper on which queries/questions need to run (or asked) to gather information on tables, settings etc.? I'd appreciate any ideas or suggestions from experienced SQL DBA Consultants.
Thanks in advance.
January 10, 2005 at 6:36 am
I'm having a brain drizzle:
Servers:
How many CPU's?
How many different physical drives?
What's the RAID setup?
How much space on the hard drives?
How much RAM?
Set up a perfmon with a good dozen metrics and put a shortcut on the desktop to launch when you want a quick look under the hood.
SQL:
How many db's?
Any named instances?
Are the backup strategies sound? Mainenance plans or homegrown?
Check taskpad view in EM for each DB.
What the value of @@version?
Run SQL profiler and get a feel for what applications/users are hitting the db's.
Familiarize yourself with all the jobs on the server.
Familiarize yourself with all the DTS packages on the server.
January 10, 2005 at 9:44 am
This is a good article to read if you'r walking into a new and unfamilier environement:
http://www.devarticles.com/c/a/SQL-Server/How-to-Perform-a-SQL-Server-Performance-Audit/5/
January 11, 2005 at 4:45 pm
thanks all for the suggestions
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply