Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2007-10-01 : 11:28:14
|
| Hi,I read this in an article:"Periodically use the SQL Profiler to continuously search for table and index scans"How do we do that pls? where is it located in Profiler?Thank you |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-01 : 11:37:40
|
| Scans |-> Scan:Started |-> Scan:Stoppedbut i'd suggest you first look at query duration and then manually inspect the execution plans._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-01 : 12:21:40
|
| I think you need to read up on how to tackle a poorly performing application. I don;t think we are going to be particularly helpful to you answering one-off questions out of the blue, although I think we can help with the specifics once you get under way.www.sql-server-performance.com has some good checklists with detailed descriptions of Why/How etc.Kristen |
|
|
|
|
|
|
How do we seacrh for table and index scans