No data available on Analysis

SQL Server performance monitoring and alerting

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

No data available on Analysis

Postby nigelhooper » Thu Sep 08, 2011 12:41 pm

Whenever I try to look at any of the entries on the Analysis tab it always says "No data available between X and now." Where X is 10 minutes ago.

The overviews tab also appears to be missing lots of data.

The C:\\Documents and Settings\\All Users\\Application Data\\Red Gate\\Logs\\SQL Monitor 2\\Base Deployment*.log files have lots of entries as follows:

2011-09-08 11:24:53,579 [ 14] WARN RedGate.Response.Common.SmartAssembly.HeadlessUnhandledExceptionHandler - Report last sent at 09/08/2011 08:51:50. Report send skipped.
2011-09-08 11:25:01,048 [ 14] WARN RedGate.Response.Common.Utilities.Scheduling.JobRunner - Unhandled exception in job run: JobRef(DataCollectionScheduler:Root[].[Cluster][[Name]=goldeneagle].[Machine][[Name]=], IntervalJobSchedule(00:00:15))
System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "Cluster_Machine_LogicalDisk_UnstableSamples_Cluster_Machine_LogicalDisk_Keys". The conflict occurred in database "RedGateMonitor", table "data.Cluster_Machine_LogicalDisk_Keys", column 'Id'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
at (Object , DataTable )
at #vgv.#KZz.#MZz(SqlBulkCopy , SqlConnection , SqlTransaction , DataTable )
at #onv.#zov.#Ahz(SqlConnection , IDictionary`2 )
at #onv.#zov.#Tbo(#hjv , #CJv , IEnumerable`1 )
at #5mv.#eov.#fDv(#MJv , #hjv , #hjv , Boolean )
at #5mv.#eov.#t.#B3.#bcz()
at (Object )
at #jZ8.#Xf8.#2f8(#8l8 )


The SQL monitor was installed a couple of months ago by our DBA who has since left, I believe that it was working before he left but I am not sure.

It appears that we have SQL_Monitor_2.3.0.334.exe installed.

How do I fix this?
nigelhooper
 
Posts: 3
Joined: Thu Sep 08, 2011 12:30 pm

Postby priyasinha » Thu Sep 08, 2011 3:30 pm

Hi Nigel,

Are there any connection errors on Configuration > Monitored servers page?

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby nigelhooper » Thu Sep 08, 2011 3:36 pm

There are no connection errors on the Configuration > Monitored servers page.
nigelhooper
 
Posts: 3
Joined: Thu Sep 08, 2011 12:30 pm

Postby priyasinha » Thu Sep 08, 2011 3:41 pm

Hi Nigel,

Could you please send me the base monitor log files to priya.sinha@red-gate.com? It should be in C:\\ProgramData\\Red Gate\\Logs\\SQL Monitor 2 or equivalent location.

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby nigelhooper » Fri Sep 09, 2011 2:31 pm

If any one else has the same problem, I solved it by restarting the SQL Monitor 2 Base Monitor service.
nigelhooper
 
Posts: 3
Joined: Thu Sep 08, 2011 12:30 pm

Same issue, no solution...

Postby KristofDM » Tue Jun 05, 2012 8:22 am

Restaring the BASE 3 service helped me out!
ty ;)
KristofDM
 
Posts: 3
Joined: Tue Jun 05, 2012 8:20 am


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 1 guest