SQL Server 2008

Question

Please help me regarding my two queries.

1. Is there any inbuilt tool for auto documentation in sql server 2008, if not then please suggest me the tools which i can use for auto documentation.

2. Is there any tool for Performance monitoring in sql server 2008 , if yes then please help me to how to use it.

Thanks in advance.

Answer 1

Hi Sac269,

For auto documentation BOL(Books online ) is the best choice. it can be installed at the time of sqlserver installation.

For performance monitoring you can use ACTIVITY MONITOR ,which with SSMS(MAnagement Studio).in this you can monitor the network Io, bufferIO, wait types ,blocking queries and many features which you will come to know as you use it.

Apart from that for performance tuning you can use DTA(database tuning adviser)

I hope this helps.

Answer 2

Hi Sushil ,

Thanks for your reply. Please help me that how to check BOL is already installed or not , whereas SQL server is already installed and Please tell me , how to use it for auto documentation.

Thanks

Answer 3

Hi

Follow any of these steps u will get BOL

• From the Start menu - Click Start, point to All Programs, point to Microsoft SQL Server,(Documentation or Tutorial) point to Help & Community, and then click Books Online.

• From SQL Server Management Studio - On the Help menu, click Help .

• From SQL Server SQL Server Data Tools (SSDT) - On the Help menu, click Help.

• From F1 or Help buttons in the user interface - For context-sensitive information, press F1 on your keyboard, or click Help in the user interface dialog box.