User profile for PDinCA

THIS FILE IS CORRUPT! PLEASE ADD A VERIFIED "GOOD" ONE, PLEASE. / comments

THIS FILE IS CORRUPT! PLEASE ADD A VERIFIED "GOOD" ONE, PLEASE.

0 votes

Hello Priya, I can confirm that I merely unlicensed the original server. The tell-tale "oops!" came to light when I tried to access the heavily populated "exclude list" of strings for a Long Running Query Alert. The entire list was gone. I had clicked to customize the Alert on the NEW cluster and tried to use the OLD as the reference - two years of customization to quieten down "noise" was well worth copying over... I then looked for other customizations on the original cluster and none existed other than 3 under the "Local" node - nothing for jobs, database, etc. As the new cluster went live over 2 weeks ago, I have been customizing the Alerts over that time. In addition, the hosting Company has now decommissioned the cluster and I have removed it, along with history et al from the RG DB, so there's no help you can provide... Thanks for trying, though, that is certainly appreciated... (Now if only I had that Export file of customizations... [image] ) / comments

Hello Priya, I can confirm that I merely unlicensed the original server. The tell-tale "oops!" came to light when I tried to access the heavily populated "exclude list" of strings for a Long Runnin...

0 votes

DISASTER! BE WARNED! In the course of my support call, Pasadena Office, I was instructed to temporarilly unlicense the original cluster. DO NOT COMPLY! ALL, yes, ALL customized alerts at all levels below (local) are GONE, GONE, GONE! DOES THIS "CUSTOMER EXPERIENCE" ADD ANY IMPETUS TO THE NEED TO RAPIDLY DEVELOP AN EXPORT/IMPORT/CLONE FACILITY, EVEN IF IT ISN'T IN THE UI PER SE? Yours, sincerely hosed Stephen / comments

DISASTER! BE WARNED! In the course of my support call, Pasadena Office, I was instructed to temporarilly unlicense the original cluster. DO NOT COMPLY! ALL, yes, ALL customized alerts at all levels...

0 votes

I am DEEPLY saddened by the response from RG Support that boils down to a "no can do - you're on your own". Having been a staunch supporter of Red Gate for over 7 years, this is a sad day - a sound demerit earned! The only "plus" and it's a very small "plus" is that Support stated, "There is a feature request to implement a feature to allow for the export of the custom/customized alerts in SQL Monitor. The number for your reference is SRP-3871." Is there a UserVoice for SQL Monitor I can add this to, with the SRP reference, unless there's one there already, of course...? Sorry, the other "plus", but not product related, is that RG supplied two additional 14-day licenses at my request so I can actually do the work. THAT IS APPRECIATED or I'd be dead in the water (once a server's keys are taken away, you can't see the configurations any more, so be warned!) As SQL Monitor is on version THREE, one would expect that "mature features" would exist whereby migrations and replications would be a snap. I'd like to know just how seriously is Red Gate "considering" SRP-3871 for inclusion in the next major release...? I can't be the only person needing to export, rename server, import, can I? I only have 5 databases and about 30 jobs to configure but having looked at the configuration page and the hierarchy of Alerts with override designations and having to drill into each one to get the details, this would be a ridiculous undertaking for anything like some of the servers I've read about on the 'net! As it is, today will be entirely taken up with manually viewing then recreating all my custom alerts, custom metrics, et al, down to jobs and databases. What a monumental waste of time! Would the Product Manager care to chip in some insight, please? Would the Support Team kindly work with Development to construct a simple set of T-SQL scripts that can "CLONE ALERTS FOR A SERVER/CLUSTER"? Cloning serves for both server addition and server replacement, BTW. How hard can this really be for the Company that made the product - seriously...? Frustratedly, but still a Red Gate advocate, Stephen. / comments

I am DEEPLY saddened by the response from RG Support that boils down to a "no can do - you're on your own". Having been a staunch supporter of Red Gate for over 7 years, this is a sad day - a sound...

0 votes

Hi Randy, If you're on a dev workstation and have a MSDN subscription, you could get the SQL2008R2 iso and install just the tools. I've found that SQL 2005, 2008/R2 and 2012 are all tolerated without issue, with SQL Prompt installed, too. All are Enterprise Edition, with a few Standard instances thrown in and a bunch of Express flavors from 2005 and 2008R2. Hope this helps... UPDATE: Dang! First ever issue - right-click Edit Table gives a nasty prefix-suffix error... Try again and the Edit Table window is all grey. At least it works for everything else - so far! / comments

Hi Randy, If you're on a dev workstation and have a MSDN subscription, you could get the SQL2008R2 iso and install just the tools. I've found that SQL 2005, 2008/R2 and 2012 are all tolerated witho...

0 votes

Sadly, that didn't change anything. The Alerts query in the RDL has two places where the CONVERT() function states 105 as the format code - that's ITALIAN. CONVERT (varchar, DateTimeRaised, 105) AS AlertDay , CASE WHEN @TimeInterval = 'Hourly' THEN CONVERT (varchar, DateTimeRaised, 105) + ':' + LTRIM(STR(DATEPART(hh, DateTimeRaised))) + 'h' ELSE NULL END AS AlertDayHour Can I suggest that the RDL be modified so that when "Daily" just the date portion is returned, else the date plus hour in a CAST( x AS datetime) field (from your util.tick-conversion). IMO, the "h"-style can be disposed of in favor of a standard-appearance of date+hh:00 to obviate format and content issues. Then code an expression in the chart's x-axis Format code, which it can have, despite there not being an expression icon next to it: =IIF(Parameters!TimeInterval.Value="Daily","d","g") You won't then need the expression for the x-axis label value. This boils down to: allow formatting to be performed upon presentation, i.e., in NOT in the underlying query... How does this sound to you... / comments

Sadly, that didn't change anything. The Alerts query in the RDL has two places where the CONVERT() function states 105 as the format code - that's ITALIAN. CONVERT (varchar, DateTimeRaised, 105...

0 votes

Both are now compatible and run fine. Many thanks. / comments

Both are now compatible and run fine. Many thanks.

0 votes

Great - very readable - no issues. Nice that the Reader XI offers one the ability to convert to docx... Thanks. / comments

Great - very readable - no issues. Nice that the Reader XI offers one the ability to convert to docx... Thanks.

0 votes

Upgraded to 3.2.1.231 on Feb 19th. Initially thought it was a horrible rev because: 1) Performance Data is forever "loading..." 2) Cannot use the Older/Newer links 3) Opened a new tab and when closed it left its imprint over the Monitor page, or a grey page background. I pulled that bug report - until today, when I'm back to those issues... Am certainly on the latest Chrome Version 24.0.1312.57 m. Series of actions today: Monitor was open at the Overview page for the cluster. . Configuration ==> Licenses . Alerts . Detail a Job Failed alert. Cleared it. . Detail a R: Drive space alert. Configured the Alert to disable it. . Detail a Q: Drive space alert. Configured the Alert to disable it. . Detailed a "HarddiskVolume" Alert, which is VERY confusing as all it says is 0 used, 0 free, etc. Don't even know what it is because the Performance Data is still "Loading...". The page is STONE COLD DEAD apart from the title bar's "Help" [image] , which at least allowed me to get to the forum. Yesterday I could click the main Overview/Alerts/... tabs and change the page, but the content was nixed after the first "Loading..." issue. I just tried to view the Monitor page - my Forum page is what is showing, although the mouse pointer does change as I move over the page's controls, so something is registering despite being unusable. Perhaps what was done to accommodate IE10 (IE% = Browser of last resort) messed up Chrome... I was on the immediately prior rev of SQL Monitor and had no rendering or freezing pages issues whatsoever. Underlying OS is Windows 2008 SP2. Any other assistance I can give? If this isn't resolved or in analysis, I'll have to revert... / comments

Upgraded to 3.2.1.231 on Feb 19th. Initially thought it was a horrible rev because: 1) Performance Data is forever "loading..." 2) Cannot use the Older/Newer links 3) Opened a new tab and when clo...

0 votes

Hi Chris. Thanks for the swift follow-up. My repository is only 20GB. I have a 14-day max retention and some at 7 days. I only monitor one SQL Cluster (Budget-distressed for any more - need 3 more!). The unusable page is probably due to the performance data not loading. The page-litter is also reproducible under the same "Loading..." condition, so they're symptoms, not separate bugs methinks. Regards. / comments

Hi Chris. Thanks for the swift follow-up. My repository is only 20GB. I have a 14-day max retention and some at 7 days. I only monitor one SQL Cluster (Budget-distressed for any more - need 3 mor...

0 votes

How can we help you today?

PDinCA

Comments