October 10, 2008 at 7:53 am
Hi experts,
I ran profiler in one of the database which is using an application.But the profiler shows the procedures running behind only when a particular link is select from the application.The server is SQL Server 2000 with SP4 .The connection string in that application is pointing to only one database on which am running the trace.please help me
TIA
October 10, 2008 at 8:00 am
What do you want help with? I'm not sure I understand what's wrong.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 10, 2008 at 8:05 am
If possible check the code that is executed with this link..if not include counters that pertain to writes to that specific database. Make sure to add filters so as not to be overwhelmed by the output shown by profiler...Hope this helps!!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 10, 2008 at 8:05 am
Corretion : Counters that tell about reads and not writes.
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 10, 2008 at 8:53 am
still the same result :-(..
October 10, 2008 at 8:57 am
Gila,
When i ran trace against a database accessing an application its not showing any result but when i click a particular link on that application its showing an sp is being executed for all other links nothing happens in trace. 🙁
October 11, 2008 at 7:46 am
Do you have any filters on the trace? Are you sure that the app's pointing at this database?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply