Comments
Sort by recent activity
Thanks for examining the files.
I'm still left with the fundamental issue of SQL Monitor issuing an "Instance Offline" when, as you pointed out, the cluster didn't failover, therefore the instance was clearly not "offline" in any way that affected the Production website...
I'm tempted to simply DISABLE the Instance Offline Alert as it is very much "noise" for every one of the 11 times it has occurred over the last 54 hours.
The Base Monitor and Cluster being monitored are hosted 2,500 miles away. Do you suggest I have the Hosting Company look into why the 2 boxes appear to lose each other? Out of interest, I have a T-SQL Job running a Stored Procedure locally that pulls data every minute over a Linked Server from the Cluster DB to a Demo DB on the same box as the Base Monitor - it NEVER has a connectivity issue although it typically runs for 45 to 50 seconds of every minute. Care to comment? Re the Log Files I sent:
I noticed there were a LOT of "ERROR" messages recorded. Please comment on them as an ERROR to me is significant and I'd like to be assured that the Monitor is not missing something I need to be aware of. / comments
Thanks for examining the files.
I'm still left with the fundamental issue of SQL Monitor issuing an "Instance Offline" when, as you pointed out, the cluster didn't failover, therefore the instance ...
Email has been sent with a set of 5 Base Monitor log files. The Web Log files contained just informational lines and very few of them, so I omitted sending them.
Thanks. / comments
Email has been sent with a set of 5 Base Monitor log files. The Web Log files contained just informational lines and very few of them, so I omitted sending them.
Thanks.
The 1st instance made sense but it doesn't help with the 2nd and 3rd where SQL Server noted nothing and the only thing saying anything was offline was SQL Monitor. Where else can I look, please, for evidence of the 2nd and 3rd being real outages... / comments
The 1st instance made sense but it doesn't help with the 2nd and 3rd where SQL Server noted nothing and the only thing saying anything was offline was SQL Monitor. Where else can I look, please, f...
Hi Ben,
No configuration changes were made at all, simply ran the installer from the download and extract.
Base Monitor and Data Repository are both on the same machine as the IIS7 website.
As Murphy's law would have it, today it is running like lightening! Must have enjoyed the rest overnight.
Service spikes to 53% when the UI is asked to display an Alert's detail.
There's actually nothing but the Red-Gate Monitor and Idera's Defrag Manager currently on the machine in question and the latter showed near flat-line CPU usage throughout the problem time and is still showing 0%.
And while I looked up the sqlservr.exe CPU usage, having requested a "Long Running Query" Alert detail - 15 seconds elapsed, the UI spiked to 74% and SQL spiked to 44% to begin with, then back to its typical 0 to 3%. Murphy is active today!
Tried a selection of pages besides Alerts and the Overviews came up fast, as did the drilldown on the cluster. The Analysis page is also molasses - selected just the "Avg. CPU queue length" for the default 10 minutes and, three minutes later, I'm still waiting... The hourglass is shown over the graph area and the progress bar is solid blue; the status bar says it is downloading the header.png background, for what it's worth.
Happy to have you diagnose with ANTS. Need help with the install as I'm no UI developer and have no experience with ANTS though I've heard of it and prior site used it to good effect. Let me know.
FYI: Likely to be "gone" from 14:00 Pacific time on Dec 23rd until the New Year.
Happy Christmas.
Regards, Stephen / comments
Hi Ben,
No configuration changes were made at all, simply ran the installer from the download and extract.
Base Monitor and Data Repository are both on the same machine as the IIS7 website.
As Murp...
"Improved" is relative... Still takes 15 seconds to pull up a log-running query alert from today, and it is the most recent alert I have, comprising somewhat little text content.
Error: 102, Severity: 15, State: 1 Error: 102, Severity: 15, State: 1 -- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed
Error: 102, Severity: 15, State: 1 set quoted_identifier off select @@microsoftversion select convert(sysname, serverproperty(N'servername')) SELECT ISNULL(SUSER_SNAME(), SUSER_NAME()) SET TEXTSIZE 1024 EXEC dbo.spr_UpdateMeterUsage
Not sure that emailing your support colleagues will speed anything along as both you and I will be otherwise occupied until Jan 3. If you feel it would be productive, you could always forward your additional thoughts to them internally, perhaps?
Enjoy the Christmas break. / comments
"Improved" is relative... Still takes 15 seconds to pull up a log-running query alert from today, and it is the most recent alert I have, comprising somewhat little text content.
Error: 102, Sever...
Thanks!
I like the simplicity [image] / comments
Thanks!
I like the simplicity
MOVE as in there will be 1 and only 1 Web Service, located in the DMZ.
We have no clue about ISA servers, sorry.
Effectively we want to install the web service in the DMZ and lose no license/password/alert configurations - I've already made a load of Alert configuration adjustments. Then uninstall the current web service.
Is there a straightforward set of steps to achieve this, please?
Thanks. / comments
MOVE as in there will be 1 and only 1 Web Service, located in the DMZ.
We have no clue about ISA servers, sorry.
Effectively we want to install the web service in the DMZ and lose no license/passwo...
Generating a sdc project file for the table concerned, then using XML Notepad 2007 to make the faulty sdc file look like the kosher one works fine. Glad RG chose to use straight XML project files. [image]
Consider this a closed ticket, please. / comments
Generating a sdc project file for the table concerned, then using XML Notepad 2007 to make the faulty sdc file look like the kosher one works fine. Glad RG chose to use straight XML project files....
Update 1: I've only had the latest version installed on the box - purchased four weeks ago, so it isn't a residual artifact from an older version.
Will attempt the "only concerned about this table" suggestion. / comments
Update 1: I've only had the latest version installed on the box - purchased four weeks ago, so it isn't a residual artifact from an older version.
Will attempt the "only concerned about this table"...
You are correct on all points. This is exactly what I'm seeing. I'm guessing that the way SSMS intervenes means it's actually pointless creating a constraint WITH CHECK as SSMS will always script it as a 2-part NOCHECK then ALTER-CHECK... / comments
You are correct on all points. This is exactly what I'm seeing. I'm guessing that the way SSMS intervenes means it's actually pointless creating a constraint WITH CHECK as SSMS will always script...