Error Log

  • Hi Team,

    In my database, insertions into error log is more than 150000 records per day, when i want to retrieve error log for particular date (1 week before records) by giving time stamp, it is taking morethan 45 mins to retieve records.

    is there any easy way to retrive fast or insert particular date error logs in to .sql, .txt, .xls file.

    Please need you help.

  • Please post the table structure along with the indexes.

    Have you tried creating an index on your "time stamp" column?


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply