asked
need to Analyze existing SQL DB status of production ?
HI all, I am new DBA, trained on sql DBA 2008 & 2012 , my first assignment (production project). activity to 1. Analyze existing SQL DB status in production! this environment is already built an dhaving sql 2008 instance installed and data bases running with phy disk storage assigned 2TB. also soon i need to configure log shipping. what are the things i have to capture in the sql envirnment(want to have prsent Inventory) like what are tables , performance, sa accounts etc. ? also what are essintial(mandatory things to be configured )on stand lone sql server? Please help. Your responses are welcome. sql cmd/querries are highy appriciable.
This site functions according to votes. For all helpful answers below, show this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer.
Hi there,
Sounds like you need some pointers for the accidental DBA: https://www.sqlskills.com/help/accidental-dba/
There is also a book from Jonathan Kehayias: https://www.red-gate.com/library/troubleshooting-sql-server-a-guide-for-accidental-dbas
I'd suggest starting with Brad's Sure DBA Checklist. It's a good starting point for understanding all that you have to do. After that, monitoring is a huge topic. There is a lot involved. Personally, I'd suggest getting a third party tool because you'll be much better off taking someone else's work and applying it. But, if you have to do it yourself, start small and grow slowly. You can impact performance by monitoring, so you want to be very cautious.
For more details on what to monitor and how to monitor it, I'd suggest two books, one free, one not. The free book is the Troubleshooting SQL Server. The not free book is SQL Server Query Performance Tuning.
16 People are following this question.
