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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2006-09-12 : 01:06:02
|
| hello friends sorry for this basic question.i heard a word sql profiler.i tried through BOL, but not got any good information how to start and from where to start. can anybody give me some brief about thisthank you very much |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-12 : 01:35:26
|
| It's an application that's installed when you install the Client tools that will allow you to see exactly what statements are being run on your database. It's a good gauge of server load and also useful for debugging apps that you can't step through. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2006-09-12 : 01:55:29
|
| thank you for the information timmy.where is this sql profiler? |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-12 : 02:14:24
|
| Should be on your Start menu under the SQL Server group |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-09-12 : 02:16:48
|
| It's also in google..-ec |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-12 : 02:23:39
|
| http://www.microsoft.com/technet/prodtechnol/sql/70/tips/sqlprof.mspxChirag |
|
|
|
Luis Martin
Yak Posting Veteran
54 Posts |
Posted - 2006-09-12 : 10:58:45
|
| Also is a good tool to find out long queries and try to optimize. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
sql profiler