Answer: It's a tool that ships with SQL Server to profile sql querie and fine tune slow performance degrading sql queries by looking at how sqlsever executes them . It contains tools like index tuning wizard to improve performance.Go to http://microsoft.msdn.com and search for SQL profiler for more detailed information on how to use it and what features are available with ample examples provided.
It's a tool that ships with SQL Server to profile sql querie and fine tune slow performance degrading sql queries by looking at how sqlsever executes them . It contains tools like index tuning wizard to improve performance.Go to http://microsoft.msdn.com and search for SQL profiler for more detailed information on how to use it and what features are available with ample examples provided. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
There should not be any Spelling Mistakes.
There should not be any Gramatical Errors.
Answers must not contain any bad words.
Answers should not be the repeat of same answer, already approved.
Answer should be complete in itself.
Related Questions
View Answer
What is the use of database index (apart from fast searching of records);What is use of composite key ?
Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employye table and department table with employee having department no.