October 28, 2011 at 9:23 am
Hello,
I'm trying to generate a trace (tuning template) with Profiler regarding a .NET application that is running too slow. The only particulars about the application is that is connecting with LINQ to stored procedures.
What I find once I start the trace I can load the mail screen and go to a summary page, wit once I click to a detail page, the explorer gets waiting for response forever (I've left it up to 20 minutes). Once I stop the profiler, the page loads in less than a minute. Tried several times with the same results. There are no other activity on the DB other than the web app.
I'm using SQL Server 2008 R2 and the application is with .NET 3.5.
Any ideas? Why is the tool meant to help solving blocking issues blocking the app? :w00t:
October 28, 2011 at 11:27 am
My 2 cents..
Dont run the profiler on the server... run a server side profiler(script) through a job..that should have very less over head..also select only those events that you need..
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply