Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
User Error Message Error 3615 in SQL Profiler

Answered User Error Message Error 3615 in SQL Profiler

  • Wednesday, June 27, 2012 9:00 PM
     
     
    Sign In to Vote
    0

    Hello,

    I am seeing 5000 of this type of error per second in a server. However, the TextData is similar to below. Can someone enlighten me if I need to get worried about this?

    Scan count 2, logical reads 6, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

    Thanks

    Thanks.

     

All Replies

  • Wednesday, June 27, 2012 9:20 PM
    Moderator
     
     
    Sign In to Vote
    0
    It seems you have connections with SET STATISTICS ON running queries against your databases. I would gess a devloper left that unintentionally. It carries overhead, of course, but hard to say whether it makes a significant difference in your environment.

    Tibor Karaszi, SQL Server MVP | web | blog

     
  • Thursday, June 28, 2012 6:07 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi ASR,

    When STATISTICS IO is ON, the amount of disk activity is displayed. I think it is OK.

    SET STATISTICS IO (Transact-SQL): http://msdn.microsoft.com/en-us/library/ms184361(v=sql.105).aspx.

    If you have any problem, please post the error messages in detail and feel free to let me know.

    TechNet Subscriber Support
    If you are     TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

    Thanks,
    Maggie

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.