Thursday, June 16, 2011

How to read the error logs in SQL server 2005\2008?

exec xp_readerrorlogs

Please read the below link before running it:

http://support.microsoft.com/kb/973524
Posted by at

2 comments:

  1. MaroofAugust 3, 2011 at 1:46 AM

    Satya Ji,
    I would like to know,whether restarting the database server does have any impact on the performance of the system?

    ReplyDelete
  2. BodhisatyaAugust 9, 2011 at 8:58 AM

    No. Initially after the instance starts you might find it faster but slowly the bottlenecks would creep in and make it slower.

    ReplyDelete

Subscribe to: Post Comments (Atom)