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 |
|
dandrade
Starting Member
3 Posts |
 Posted - 2004-11-08 : 11:58:26
|
| I have set profiler using template "Worst Performing Queries" in SQL 7.0 and also "SQLProfilerTSQL_Duration" in SQL 2000. Very cool, I can see every t-sql and sproc. However, I'd like to know which page is submiting those queries. Is there a data column for this?How can I tell which pages in my web site or application (ASP, CFM, other) have slow queries?Thanks |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-11-08 : 12:17:19
|
| As far as I know, there isn't. You could make a call to some sort of logging funtion at the top of yor page that might help you identify which page is calling what procs.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
dandrade
Starting Member
3 Posts |
Posted - 2004-11-09 : 08:30:29
|
| Searches I have done. Find answers I have not.Problem with your approach is I would have to bookmark about 19GB of pages. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-11-09 : 11:54:22
|
| 19GB of HTML / ASP pages? Wow!I'm not sure I understand the reasoning in finding the pages in question. Why not just fix the slow running queries? Another option would be to copy your production environment to a test environment and "click" to each page to see what queries execute. I just don't see an easy way of figuring out which pages call what queries, unless it's ASP.net. There might be some ways to do it with ASP.net and tracing.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-09 : 12:12:14
|
| Have you got an include file used on every page? You could have that put the SCRIPT name into some variable which was passed to the logging process.We allocate each page, and each SProc, an ID and pass that, together with the Session ID, to our logging function.Kristen |
|
|
|
dandrade
Starting Member
3 Posts |
Posted - 2004-11-12 : 16:57:59
|
| We index Law related stuff like cases, rules, regulations...Ours is a web site developed with Cold Fusion. And yes, I think ASP.NET can trace pages. At least I have seen some ASP.NET objects in Profiler.I like the idea of using an INCLUDE file. I'll see what can be done. Anyway, I am relying on that "Worst Performing Queries" template.Thanks. |
|
|
|
|
|
|
|
|
SQL Profiling those web pages