Activity overview
Latest activity by endix
Apologies for reviving the old thread, but how exactly does one get alerted about "transaction log full"? Seems the implied answer is to enable "SQL Server log entry" alert with a regex for "The transaction log for database ... is full". Am I right? / comments
Apologies for reviving the old thread, but how exactly does one get alerted about "transaction log full"? Seems the implied answer is to enable "SQL Server log entry" alert with a regex for "The tr...
disk space reporting for mountpoints
I have log and temp disks mounted as folders, without a drive letter. On Disk Space alert page, the top part is correct, but the breakdown that follows is showing wrong numbers, including negatives...
I subscribed to this topic, to be on top of updates. May I ask that when the next major version arrives, you do not simply abandon this thread, but maybe post one final message stating so. Thanks.
Better yet, keep the board and the announcements thread going forever, not starting a new one for each major release. And if you don't want to do that, maybe you could start a separate board with one announcements topic per product.
Just looking for something that I can set once and forget, and be notified about SQL Monitor releases ongoingly (if there is such a word). / comments
I subscribed to this topic, to be on top of updates. May I ask that when the next major version arrives, you do not simply abandon this thread, but maybe post one final message stating so. Thanks.
...
I don't think there is a relation to any particular page. The trace file I uploaded shows that there is a huge number of inserts happening all the time, regardles of current page.
Note, the SQL Server itself is handling the load and remains responsive. It must be the Base Monitor service that is holding things up. / comments
I don't think there is a relation to any particular page. The trace file I uploaded shows that there is a huge number of inserts happening all the time, regardles of current page.
Note, the SQL Ser...
It takes 1 min 30 seconds for global dashboard and 50 seconds for /overviews/global. Used to take about a second, it never bothered me, so I did not try to measure it. / comments
It takes 1 min 30 seconds for global dashboard and 50 seconds for /overviews/global. Used to take about a second, it never bothered me, so I did not try to measure it.
There is also a trace file uploaded to https://redgatesupport.zendesk.com/hc/e ... ests/66018 / comments
There is also a trace file uploaded to https://redgatesupport.zendesk.com/hc/e ... ests/66018
How many Windows servers and SQL instances are you monitoring?
48 and 67
how many alerts you have
216628
the data purge settings for "Alert data"
2 months
include the URL diagnostics from Configuration > About > Website performance diagnostics
GLOBAL OVERVIEW PERFORMANCE DIAGNOSTICS
Enable loading time indication on Global Overview
INTERNAL DIAGNOSTICS
PriorityCumulativeFires 65200
PriorityCumulativeMisfires 11
DataCollectionCumulativeFires 4127028
DataCollectionCumulativeMisfires 2890
WATCHDOG
The URL /watchdog will return the text string 'OK' if at least one machine is being monitored successfully.
URL DIAGNOSTICS
URL Time (ms) No. Requests
Average Min Max Total Success Error
/ 106.10 53 546 10 10 0
/GlobalOverview/GlobalData 3174.30 2906 3828 10 10 0
/AlertInbox/AlertsData 650.70 578 806 10 10 0
/Alerts/Inbox 62.50 50 100 10 10 0
/AlertInbox/ChannelsData 2246.50 2099 2685 10 10 0
/AlertInbox/ListFilterSettings 57.50 18 75 10 10 0
/ConfigureLicensing/GetData 58.20 39 156 10 10 0
/static/5.2.1.3670/Scripts/RedGate.Response.js 84.90 66 131 10 10 0
/Configuration 24.10 20 42 10 10 0
/Diagnostics/BaseMonitorNoOp 57.00 54 71 10 10 0
/Diagnostics/RepositoryNoOp 57.30 55 61 10 10 0
/ comments
How many Windows servers and SQL instances are you monitoring?
48 and 67
how many alerts you have
216628
the data purge settings for "Alert data"
2 months
include the URL diagnostics fr...
5.2 slow
Just upgraded to 5.2 and it's really slow to load Overview or Alerts pages.
I think my question can be answered clearly. It's not so much an issue. I am just looking for clarification.
What column in what system view does it correspond to? / comments
I think my question can be answered clearly. It's not so much an issue. I am just looking for clarification.
What column in what system view does it correspond to?
ignore certain wait types
Is it possible to exclude certain wait types when determining long runing queries? My first candidate would be SP_SERVER_DIAGNOSTICS_SLEEP.