Error Occurred...

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Error Occurred...

Postby maddave » Thu Sep 05, 2013 9:05 am

Hi, I am not sure if this is something caused by my setup, or the product.

Throughout the day, whilst the SQL Monitor webpage is open, I get errors when the page auto refreshes. A full F5 refresh of the browser resolves the issue, but this is happening more and more lately. Could anyone assist in what could be causing the problem?

Here is the error from the exception:

Code: Select all
An error has occurred. Try refreshing the page: the problem may be temporary. Error details

    /GlobalOverview/GlobalData: 500 Internal Server Error
    #5jv.#mkv: System.Data.SqlClient.SqlException was thrown by method Query on service DataPresenterService:
    System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
    at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
    at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
    at System.Data.SqlClient.TdsParserStateObject.ReadByte()
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest)
    at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
    at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName)
    at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName)
    at #Zfdc.#4fdc.#mFA(IsolationLevel )
    at #I0qb.#8UBc.#5Ev(#Vfdc , IDictionary`2 , #IJv , #Shv , PropertyKind , IEnumerable`1 , #hjv )
    at #I0qb.#8UBc.#eBv(#Vfdc , #hjv , #IJv , #u0B )
    at #I0qb.#8UBc.#z2.#Bwv(#IJv , #u0B )
    at #Phv.#ajv.#y2.#BdR(#IJv , #u0B )
    at #Phv.#ajv.#Pvv(#CJv , #IJv , #hjv , Func`3 )
    at #Phv.#ajv.#Pvv(#CJv , #IJv , #hjv , Func`3 )
    at #Phv.#ajv.#Pvv(#hjv , Func`3 )
    at #I0qb.#8UBc.Query(#Kru , #Aru , #hjv , #hjv )
    at #I0qb.#zov.Query(#Kru , #Aru , #hjv , #hjv )
    at #Ehv.#Dhv.Query(#nxY , #Aru , #hjv , #hjv )
    at #Zmv.#6Jw.Query(#Kru , #Aru , #hjv , #hjv )
    at #Zmv.#6Jw.Query(#Kru , #Aru , #hjv )
    at #Mlv.#bmv.Query(ChannelTreeMessage`1 )
    at #Zjv.#jkv.#cxv(String , MethodInfo , Object[] )
    at RedGate.Response.Common.Networking.Client.RpcSynchronousTcpChannel.#cxv(String , MethodInfo , Object[] )
    at RedGate.Response.Common.Networking.Client.RpcProxyGenerator.#lkv.Intercept(IInvocation )
    at Castle.DynamicProxy.AbstractInvocation.Proceed()
    at Castle.Proxies.IDataPresenterServiceProxy.Query(ChannelTreeMessage`1 rootQueryTreeMessage)
    at #Mlv.#1lv.Query(Unit , IStatusLogger , #hjv )
    at RedGate.Response.UI.Website.Extensions.DataPresenterExtensions.GetChannel(IEnumerable`1 propertyNames, #v0B channelQueryTreeBuilder, IDataPresenter`1 dataPresenter)
    at RedGate.Response.UI.Website.Extensions.DataPresenterExtensions.GetRootChannel(IDataPresenter`1 dataPresenter, #y1B queryRange, IEnumerable`1 propertyNames)
    at RedGate.Response.UI.Website.Controllers.GlobalOverviewController.GlobalData(Nullable`1 date, String groupName)
    at lambda_method(ExecutionScope , ControllerBase , Object[] )
    at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
    at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClassd.<InvokeActionMethodWithFilters>b__a()
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
    at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
    at System.Web.Mvc.Controller.ExecuteCore()
    at System.Web.Mvc.MvcHandler.<>c__DisplayClass8.<BeginProcessRequest>b__4()
    at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass1.<MakeVoidDelegate>b__0()
    at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _)
    at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
    at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
    at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
maddave
 
Posts: 19
Joined: Thu Apr 11, 2013 11:48 am

Postby chriskelly » Fri Sep 06, 2013 11:17 am

Can you confirm the web browser and version you are using? and whether you are using the supplied Mono XSP WebService service or IIS? Have you tried an alternative web browser and does this show the same behaviour?
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby maddave » Fri Sep 06, 2013 11:41 am

Hi,

I am using Firefox 23, but we have a monitoring pc which uses IE 9 and the same thing happens on there.

I am using the supplied XSP webservice.

I cannot pin down how often this happens, roughly 4 or 5 times a day, and it is not a massive problem as just manually refreshing the page solves it. However it would be good to resolve it on the monitoring pc so I dont have to keep logging on to refresh it! (i.e. I'm lazy!)

Thanks.
maddave
 
Posts: 19
Joined: Thu Apr 11, 2013 11:48 am


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests