December 7, 2007 at 4:25 am
I need to inspect / audit an existing system (a pair of SQL Servers, about 10 databases), and then start to maintain it as a dba.
There is no dba at the moment, and no documentation.
I am an experienced developer (.Net, Java, BI, etc.) with some experience with SQL Server, as well.
What should I start with? Could someone help me with some links or books?
Advices at all levels are welcome, from guidelines to scripts.
Thank you in advance!
December 7, 2007 at 4:35 am
You could find a lot of scripts here to get information about the server & database configurations. Just search for "Server Information" at the top-right of this page.
Here is one of the posts to get you started....
http://qa.sqlservercentral.com/Forums/Topic430078-5-1.aspx
--Ramesh
December 7, 2007 at 5:03 am
Understand the applications hitting the servers. What load do they exert? Do they have any timed jobs or other special tasks that need to be performed on a regular basis? Do they require special permissions? Are any reports run that slow things down - if so, can you move the reports elsewhere to a mirrored database? Get a handle on database sizing requirements - is there enough space for future growth? Is the server under heavy load?
Understand the backups in place. Should they be modified? You really want to check this first!
December 9, 2007 at 2:15 am
Hi,
I think you have to write a script to check the following:
1- System configuration (OS)
2- SQL Server general details
3- Databases status and configurations
4- Space usage
5- Input /Output per Database (or Data*Log file)
6- Backup history
7- Security Audit(list of logins, user mapping, Roles memberships, orphan users)
8- Remotes servers
9- Jobs info
10- Maintenance plans
11- Expensive processes
12- locks
13- Tables structures
14- Index report
15- Services running
16- Some performances ratios.
Check the following link
http://www.sql-server-performance.com/articles/audit/main.aspx
Notes:
- You can use bunch of useful reports in SSMS (under summary tab)
- You can use DMVs which provide useful info as an example check the following link http://www.sql-server-performance.com/articles/per/index_dmv_dmf_p1.aspx
- There are also a lot of tool check
http://www.sql-server-performance.com/software/audit_reviews.aspx
Regards,
Ahmed
December 9, 2007 at 3:56 am
Thank you so much, also for the links!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply