| Author |
Topic |
|
sbalaji
Starting Member
48 Posts |
 Posted - 2007-10-22 : 15:13:59
|
| One of my application i am using is very slow,(SQL 2005 backend).I am trying to find out the tables and add index to it.But this time my profiler is skipping the records(Trace Skipped Records).Is there any settings?,so that it shows up all the records.Note: i dont have the code of the application,but i can find few tables holding 2-3 millions of records.I want to know the column name,to create index. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-22 : 15:20:20
|
| You are probably tracing too much information and SQL Profiler can not keep up.First, do not save your trace data to a table. Always save it to a file. Files can easilly be accessed as if it were a table via the trace function.Second, run SQL Profiler from a client machine and not from the database server.Third, select only the events that you are interested in. There's typically only a handful that you will need.Fourth, filter your data as much as possible. Since you are experiencing slowness, I would suggest filtering by Duration.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sbalaji
Starting Member
48 Posts |
Posted - 2007-10-22 : 16:10:18
|
| Thanks for the tips.But still i am still stuck up with the problem.I think there is a bad code in the application.Now i have to catch hold of the guys who coded this. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-22 : 16:14:23
|
| We can't help you without seeing the queries that are performing poorly. You'll need to get a correctly configured trace setup in order to provide that information to us.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-22 : 16:44:41
|
quote:
Originally posted by X002548
2. If it is, how many do you have
Why does it matter how many stored procedures there are in a database?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sbalaji
Starting Member
48 Posts |
Posted - 2007-10-29 : 17:55:25
|
| I have heard,people saying dynamic queries are bad,I just realized it,when given in the wrong hands,they build a query 91 pageslong.No wonder,why the trace missed it. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-30 : 02:56:07
|
"Why does it matter how many stored procedures there are in a database?"I think Brett was referring to "executions" rather than the number of SProcs  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-30 : 02:57:06
|
"they build a query 91 pages long"Hehehe .... well, if it was 91 pages of carefully hand tuned SQL it could be OK  |
|
|
|
|
Trace Skipped Records