I have recevied an issue which is, frequent hit for following query in SQL Server. But this line of code not used in our application DBCC SHOW_STATISTICS(N '"Demo"."dbo"."tblSettings"' , "_WA_Sys_0000000C_125F7E8B" ) WITH HISTOGRAM_STEPS I need to know 1. Why this line of code executed 2. Can we stop this line of execution

See this for more information: http://www.benjaminnevarez.com/tag/linked-servers/

Answer

Prevent running DBCC SHOW_STATISTICS

Tony Stack

640

I have recevied an issue which is, frequent hit for following query in SQL Server. But this line of code not used in our application

DBCC SHOW_STATISTICS(N'"Demo"."dbo"."tblSettings"',"_WA_Sys_0000000C_125F7E8B") WITH HISTOGRAM_STEPS

I need to know
1. Why this line of code executed

2. Can we stop this line of execution

Next Recommended Forum

Kill the user session in SQL Server

Forum Statistics

Please welcome our newest member Prajakta Wangade.
3,090,745 users have contributed to 147,405 threads and 483,580
In the past 24 hours, we have 1 new threads, 5 new posts, and 38 new users.
In last week, the most popular thread is 'Will LOV111VOL replace SharePoint worldwide?'.

Upcoming Events

View all