missing column statistics

SQL Server performance monitoring and alerting

Moderators: Colin Millerchip, priyasinha, Adam, chriskelly

missing column statistics

Postby stevenhoban » Wed Jun 11, 2014 4:00 pm

One of our servers seems to be burning extra cpu and when I have examined the default trace in profiler i see the following info:

NO STATS:([tempdb].[dbo].[##redgate_sqlmonitor_querywaitstats_server01.(local)CMSp01].[sql_handle], [tempdb].[dbo].[##redgate_sqlmonitor_querywaitstats_SERVER01(local)_CMS01].[statement_start_offset], [tempdb].[dbo].[##redgate_sqlmonitor_querywaitstats_SERVER01.(local)_CMS01].[statement_end_offset], [tempdb].[dbo].[##redgate_sqlmonitor_querywaitstats_SERVER01.(local)_CMS01].[wait_type])

Do i need to create statistics ? how shall i proceed ?
stevenhoban
 
Posts: 15
Joined: Thu Apr 18, 2013 4:41 pm

Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 1 guest