September 18, 2013 at 8:52 am
Hello all,
We are running profiler for one of our systems and the profiler shows that one specific query is executed 8000 times could this be the sql server or the packet are getting dropped by the network and it is trying again ?
see below
TextDataApplicationNameNTUserNameLoginNameCPUReadsWritesDurationClientProcessIDSPIDStartTimeEndTimeBinaryData
exec sp_executesql selectXXXXXX.Net SqlClient Data ProviderNULLDBName0201322652812013-09-18 10:43:57.9732013-09-18 10:43:57.973
September 18, 2013 at 1:57 pm
That query is being run 8000 times. What is the duration of the trace you are running?
The fact that is says .NET Sql Client is the application means someone has written a pretty chatty .NET application that is using the server.
FYI - running the Profiler GUI against a production server isn't the best idea. You should be running a server-side trace[/url].
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 19, 2013 at 2:20 pm
Thank you very much
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply