Exception: capacity was less than the current size

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Exception: capacity was less than the current size

Postby PDinCA » Thu Aug 19, 2010 10:45 pm

Client: Windows 7 Ultimate
Server: 2003 32-bit
DB: 2008 SP1

What: Viewed a deadlock. Clicked the next exception, which is a "Long running query" and the exception below occurs.

When: Every time I click on it.

SQL Response 1.3 has encountered a problem and needs to close.
If you were in the middle of something, the information you were working on may be lost.

Technical details:

capacity was less than the current size.
Parameter name: capacity


at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
at System.Collections.Generic.List`1..ctor(Int32 capacity)
at k.a.<>c__DisplayClass1.<RequestData>b__0(Object )
at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)

For the time I tried to view the Alert:
15:31:48.557|Info |AlertRepository |36 |Begining old data cleanup.
15:31:48.557|Info |AlertRepository |36 |Cleaning old data
15:32:12.837|Info |AlertRepository |36 |Old data clean complete
15:32:12.837|Info |AlertRepository |36 |Checking for deleted servers
15:32:12.837|Info |AlertRepository |36 |Deleted servers checked
15:32:12.837|Info |AlertRepository |36 |Checking for old files
15:32:12.915|Info |AlertRepository |36 |Old files checked
Posts: 582
Joined: Mon Jul 25, 2005 10:42 pm
Location: Irvine, CA, USA

Postby Anu Deshpande » Mon Aug 23, 2010 9:59 am

Many thanks for your post and apologies for the inconvenience caused.

Let us know if this happens for all the alerts on that server? Does the behaviour changes for the other SQL Server added (if any)?

Have you tried restarting the Alert Repository service? Kindly let me know if this makes any difference.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
Posts: 839
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Postby PDinCA » Mon Aug 23, 2010 5:14 pm

Of the 3 alert categories, this is the only one that causes the problem.

Alert Service restarted. UI bombs.
Posts: 582
Joined: Mon Jul 25, 2005 10:42 pm
Location: Irvine, CA, USA

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests