SQL process fragment just display "SELECT"
xexex
Posts: 56
I've received a Long-running query alert, when I open the alert detail in WebUI, it show:
*****************************
Process ID: 369
Process name: Process_Name
Host: Copmputer_Name
User: User_Name
Process login time: 15 Nov 2010 11:49 AM
SQL process fragment
Command Type: SELECT
*****************************
The report is too simple and I don't know what's wrong in our SQL statement, how can I obtain more statement information in this event?
*****************************
Process ID: 369
Process name: Process_Name
Host: Copmputer_Name
User: User_Name
Process login time: 15 Nov 2010 11:49 AM
SQL process fragment
Command Type: SELECT
*****************************
The report is too simple and I don't know what's wrong in our SQL statement, how can I obtain more statement information in this event?
Comments
Sometimes this is just the first word or entire block of SQL. This information is taken as-is from SQL Server. However, if you enable trace (small performance hit on the server you're monitoring, so do this only when debugging an active issue) you can view full SQL transcripts. In the alert details, open the SQL Process / profile trace tab and click on a process to display the captured trace.
Hope this helps,
Development
Red-Gate Software
However, when I click "SQL processes / Profiler trace", it show:
No SQL statements to display.
No statements captured for the selected process or trace was not enabled for this SQL Server instance at the time the alert was raised.
The statement can be shown in V1.3 (Alert Details => Performance snapshot)
Activating trace only affects alerts generated from that point onwards; old alerts can't be updated as trace is not retroactive. Additionally, there is a small delay (0~15 seconds) from when the alert is first generated to when trace data is attached.
Are you finding that new alerts are not being tagged with trace data?
Regards,
Development
Red-Gate Software
P.S. How can I upload screenshot on this forum?
Development
Red-Gate Software
After I enable TRACE in SQL Monitor, it doesn't show the statement.
Thanks for the feedback. I don't know why the trace data isn't being appended to the alert - I'll move some test effort on to this area. As for the truncated fragment, I'll put the relevant developer on the issue and hopefully this will be improved for 2.1.
Thanks,
Development
Red-Gate Software
http://www.red-gate.com/MessageBoard/vi ... 4099#44099
I'm monitoring a SQL Server 2000 too.
We can't upgrade to SQL monitor 2 before we fix this issue.
The SQL process fragment was not correct in SQL monitor, compare with SQL response
For the WebUI, only a part ofstatement can be displayed in Profiler Trace.
Thanks for the further info. The width behaviour of the viewer has been changed and SQL 2000 related trace issues are presently being improved. Both fixes will be in 2.1 when it goes out (TBA).
Regards,
Development
Red-Gate Software