<p>I'd like to know the standard way to benchmark a SQL Sever Query, preferably I'd like to know about the tools that come with SQL Server rather than 3rd Party tools.</p>

[{'answer_id': 34864, 'author': 'Ben Scheirman', 'author_id': 3381, 'author_profile': 'https://Stackoverflow.com/users/3381', 'pm_score': 1, 'selected': False, 'text': "<p>Use SQL Profiler.</p>\n\n<p>For .NET applications, filter that Application name by '.NET%' and you'll omit other extraneous queries.</p>\n"}, {'answer_id': 34865, 'author': 'SQLMenace', 'author_id': 740, 'author_profile': 'https://Stackoverflow.com/users/740', 'pm_score': 5, 'selected': True, 'text': '<p>set showplan_text on \nwill show you the execution plan (to see it graphically use <kbd>CTRL</kbd> + <kbd>K</kbd> (sql 2000) or <kbd>CTRL</kbd> + <kbd>M</kbd> (sql 2005 +)</p>\n\n<p>set statistics IO on\nwill show you the reads</p>\n\n<p>set statistics time on\nwill show you the elapsed time</p>\n'}, {'answer_id': 35617, 'author': 'Scott Bennett-McLeish', 'author_id': 1915, 'author_profile': 'https://Stackoverflow.com/users/1915', 'pm_score': 0, 'selected': False, 'text': '<p>+1 on the execution plan. From here you can see where all the time is being spent in your particular query. Eg. 85% of the time is spent table scanning a particular table, can you put an index on that table to improve it? etc etc.</p>\n'}]
['https://Stackoverflow.com/questions/34858', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1736/']