question

rameshvgnr avatar image
rameshvgnr 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.
mssql
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
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.
0 Likes 0 ·
@SQLShark avatar image
@SQLShark answered

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

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Ha! I was slow in typing.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.