December 16, 2016 at 7:14 am
After running my query and checking the Execution Plan in SSMS, I can see that that there is a Clustered Index Scan with a Query Cost of 100%.
I opened SQL Profiler, selected the Tuning Template, specified DatabaseName then executed my query.
I expected to see some kind of data in SQL Profiler but nothing showed up.
December 16, 2016 at 11:41 am
SQLUSERMAN (12/16/2016)
After running my query and checking the Execution Plan in SSMS, I can see that that there is a Clustered Index Scan with a Query Cost of 100%.I opened SQL Profiler, selected the Tuning Template, specified DatabaseName then executed my query.
I expected to see some kind of data in SQL Profiler but nothing showed up.
Did you double check the filter on DatabaseName? I would guess that being the issue first. You can also try just removing the filter for DatabaseName and doing a quick check (it will fill up quickly with no filter) to see if the filter was the problem.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply