Options

missing column statistics

stevenhobanstevenhoban Posts: 21
edited June 11, 2014 11:00AM in SQL Monitor Previous Versions
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 ?
Sign In or Register to comment.