Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Analyze existing SQL DB status of production

Author  Topic 

Vgnr
Starting Member

3 Posts

Posted - 2014-10-20 : 05:25:48
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.

JasUK
Starting Member

1 Post

Posted - 2014-10-23 : 05:56:48
Go here :

[url]http://www.brentozar.com/blitz/[/url]

You're welcome.
Go to Top of Page
   

- Advertisement -