New job next week, need to healthcheck databases - how??
-
Hi all,
I'm starting a new contract later on this week, and I have absolutely no idea what state the client's SQL databases are in. From what I understand I'm the first DBA they've ever had, I presume up to now they've simply installed their RDBMS and DB's in "click this button" style according to the instructions of their 3rd party vendors and the like. So, although not strictly a 'greenfield' site, it is indeed a green one (literally as well as figuratively, but I digress!!)
Any of you guys know of a good script that I can run to give me a snapshot of the health of their databases/server config settings, listing frequency/type of backups, performance stats, trans log utilisation, security etc????
Of course I could perform this audit manually, one DB and one server at a time, and will likely perform an exhaustive one anyway this week, but I'd rather know frome Day ONE whether there are any glaring issues that urgently need to be addressed.
Cheers,
Jaybee.
-
- collect sqlserver version info.
- use sp_helpdb to get a first impression of the db-settings that are in use.
- perform sp_updatestats / dbcc updateusage for all db that use "autoupdate statistics", so you are sure of recent stats.
- probably, you'll be pointed to "urgent issues" by devs or users or other collegues. That may be a good starting point.
- take you time to get to know the interests for the company, so you're not towed around by "urgent problems" all the time.
- especialy check oltp-db for tables without clustering indexes. CLI may solve a bunch of performance issues ! if you just create them arbitrarly on an incrementing key or non-nullable datetime field. Later on you'll want to create them wizely !
- But don't overact !
Good luck with this chalange.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply