SQL Server Performance

Errors in traces for appliacations that work

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by dimitrisv, Aug 11, 2006.

  1. dimitrisv New Member

    Hello,

    I use the Profiler and the Data base Tuning Advisor of SQL 2005 in order to optimize my database for my apps.

    I run a trace and analysis of my web server and here are some of the errors that I got in the reports.

    E000 exec dbo.cs_user_Get @UserName=N'jded',@UserID=0,@IsOnline=0,@LastAction=N'',@SettingsID=1000 122 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.cs_user_Get'.
    exec dbo.cs_thread_IsTracked @ThreadID=5969,@UserID=28236,@SettingsID=1000,@IsTracked=@p4 output
    select @p4 1 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.cs_thread_IsTracked'.
    E000 declare @p4 bit
    set @p4=0
    exec dbo.cs_thread_IsTracked @ThreadID=414,@UserID=1001,@SettingsID=1000,@IsTracked=@p4 output
    select @p4 1 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.cs_thread_IsTracked'.
    E000 exec dbo.cs_Section_GetSectionIDByPostID @SettingsID=1000,@PostID=44641 1 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.cs_Section_GetSectionIDByPostID'. E000 declare @p4 bit
    set @p4=0
    exec dbo.cs_thread_IsTracked @ThreadID=346,@UserID=1001,@SettingsID=1000,@IsTracked=@p4 output
    select @p4 1 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.cs_thread_IsTracked'.
    E000 exec GetUserInfoByUserName @username='savexe' 1 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'GetUserInfoByUserName'.



    The million dollar question here is this: since these stored procedure, do exist and since most of the time my application appears to behaves fine, why on earth we do get so many errors of this kind?
    Any comment will be greatly appreciated.
    There are many more errors, some of them repeat themselves hundrends of times in the couple of hours that I took the trace and most of them are ommited even in the cs event log. But then again I do get this error as well

    E000 exec dbo.cs_Exceptions_Log @SettingsID=1000,@ExceptionHash='1320592453',@Category=999,@Exception=N'System.IO.FileNotFoundException: D:Internet_SitesWWWForumforums274662ShowPost.aspx
    at System.Web.UI.TemplateParser.GetParserCacheItem()
    at System.Web.UI.TemplateControlParser.CompileAndGetParserCacheItem(String virtualPath, String inputFile, HttpContext context)
    at System.Web.UI.TemplateControlParser.GetCompiledInstance(String virtualPath, String inputFile, HttpContext context)
    at System.Web.UI.PageParser.GetCompiledPageInstanceInternal(String virtualPath, String inputFile, HttpContext context)
    at System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String url, String path)
    at System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, String path, String pathTranslated, Boolean useAppConfig)',@ExceptionMessage=N'D:Internet_SitesWWWForumforums274662ShowPost.aspx',@UserAgent=N'Baiduspider+(http://www.baidu.com/search/spider.htm)',@IPAddress='202.108.23.76',@HttpReferrer=N'',@HttpVerb=N'GET',@PathAndQuery=N'/forums/2/74662/ShowPost.aspx' 1 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.cs_Exceptions_Log'.


    Any suggestions by the gurus please?
  2. satya Moderator

    http://communityserver.org/forums/thread/541903.aspx a followup suggestion by Originator.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page