Hi,

The following link would have been very appropriate for your QOD.

http://msdn.microsoft.com/en-us/library/ms141005.aspx

--- Babu

Thank you for the easy and straight forward question....

DBCC checkdb is very resource oriented command. The database listed are system databases should not be big problem. Where as the 5 application dbs you never mentioned their sizes. The...

Even though you deleted the data from the table does not mean the pages will be removed from the table. The table will still contain empty pages. Only rebuild index...

Thank you bitbucket. Nice and straight forward question.

--- Babu

Error log and the eventlog are the best places to start with troubleshooting...

I completely miss read the question. And also I never heard of the lock escalation threshold. Good to knew it.

Learned something knew.

Good question !!!!.

If you have space in the secondary server, I would advice you to go for snapshot database using the log shipped database. Snapshot databases are very usefull for mirrored...

Please let us know the backup strategy for your primary mirror database. It seems like your transaction log keep growing each day. I am not very sure what will be...

New issue:

BUT to check the log shipping , I have created a new table in the primary database and after the next transaction log restore , I queried the secondary...

It seems like this is not for production server. Not sure though.

Sivaganesh soon you will learn cursors are not the best friend for sql solution.

--- babu

I can't understand why can't you post in universal known language.

This post can replied only by the people who knows this language.

--- Babu

The database will not shrink well beyond its initial file size created. if the database is created with 200 GB initially. And later on you have 150 GB free space,...

296 GB for a tempdb. I would say too much of activity going on from application. You said too many application is using your server.

You have default trace capturing...

Seriously?

These type of errors I used to do when I learn looping.

Never the less +1 to me.

Thanks for the very easy question.