August 12, 2009 at 7:00 am
hi pls tell how to c the o/p of the profiler and what all the perameters will observe in the test or production servers
pls give me some tips when to run profiler
pls give some query optimization technics for performence issues
thanks in advance
August 12, 2009 at 10:02 pm
experts pls reply soon
August 13, 2009 at 7:59 am
Here's a list of resources on this site for Profiler.
We would need more details in order to provide performance optimization tips. Here's a list of optimization resources on this site.
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
August 13, 2009 at 8:14 am
sivark1 (8/12/2009)
pls tell how to c the o/p of the profiler
What?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2009 at 8:37 am
GilaMonster (8/13/2009)
sivark1 (8/12/2009)
pls tell how to c the o/p of the profilerWhat?
Maybe this was typed with a cell-phone keyboard. Looks like an SMS...
-- Gianluca Sartori
August 13, 2009 at 9:18 am
GilaMonster (8/13/2009)
sivark1 (8/12/2009)
pls tell how to c the o/p of the profilerWhat?
Guessing:
Please tell me how to see the output of the profiler?
But I could sure be wrong. Whole words make communication easier, especially when attempting to communicate about technology.
Assuming I'm right, I have to ask, what do you mean? If you use the Profiler (as opposed to setting up server side traces, the preferred method), when you connect to a server and specify events and click start... you see the output in real time (don't do that on a production system though).
Or, do you mean how do you read trace output? Assuming you've set it up the right way and it's output to file, you can either open the files directly using Profiler, or you can load the data from the files into a database (again, don't use your production system for this) and then either run queries against it or, again, open the table using Profiler.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 13, 2009 at 9:19 am
sivark1 (8/12/2009)
hi pls tell how to c the o/p of the profiler and what all the perameters will observe in the test or production servers
Huh?
pls give me some tips when to run profiler
Never. Use server-side traces instead.
pls give some query optimization technics for performence issues
Best one is hire somebody who is competent in T-SQL and knows SQL Server and have them do it for you. Either perm hire or contract.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 13, 2009 at 11:13 am
Grant Fritchey (8/13/2009)
GilaMonster (8/13/2009)
sivark1 (8/12/2009)
pls tell how to c the o/p of the profilerWhat?
Guessing:
Please tell me how to see the output of the profiler?
Huhn. Now I would have thought it meant "how to conjugate the object participle of the profiler?" 🙂 I mean, clearly some help is needed with spelling, grammar, etc.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply