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 |
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
 Posted - 2004-08-31 : 02:06:50
|
| I have a database. My applications are running queries against it. How i can check sql server queries that are taking long time than required. i plan to work on worst performing queries to improve performance.Thanksmk_garg |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-31 : 02:28:05
|
| Are you using v2000? If so, you can use the profiler and it will do this for you. |
 |
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2004-08-31 : 02:55:48
|
| I am using SQL 7.But i have installed client tools for sql server 2000.I have sql profiler.never used it. any hints how i can use it.Thanksmk_garg |
|
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2004-08-31 : 03:56:34
|
quote:
Originally posted by mk_garg20
I am using SQL 7.But i have installed client tools for sql server 2000.I have sql profiler.never used it. any hints how i can use it.Thanksmk_garg
Damien helped me out with that problem in this thread.[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=24317[/url]hope that helps :)mike123 |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-08-31 : 04:48:46
|
| http://www.sql-server-performance.comMichael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2004-08-31 : 18:30:26
|
| Thanks guys!i will explore these.mk_garg |
|
|
|
|
|
|
Query Performance