User profile for PDinCA

It explains things, but in simple terms it means that I will completely ignore this Alert as it confuses, rather than points to a problem I need to address as far as I'm concerned. What happens when the job runs for the 2nd time and the alert is "active", do I get another Job Duration Unusual Alert? That's all I'd want to see - that each incident is reported to me. I can look at the occurrence history to determine if I have an ongoing issue... If there is a way to change the Alert, perhaps in a future version, so that the User can choose between a "Continuous Alert" and "Event Alert", I for one would be less confused but still able to look into a potential issue given a succession of the same Job Duration Unusual alerts. Your thoughts? / comments

It explains things, but in simple terms it means that I will completely ignore this Alert as it confuses, rather than points to a problem I need to address as far as I'm concerned. What happens whe...

0 votes

Thanks, just what I needed. / comments

Thanks, just what I needed.

0 votes

Reference-only = DB with "Numbers" table, "Dates" table", i.e., it has NO transactional implications whatsoever. I cannot reproduce the problem because Rackspace is responsible for the firewall configuration and I have no idea what they did. Whatever action they took, it caused SQL Monitor to stop monitoring and I had to re-apply the Windows credentials to the overall server row on the configuration page. The SQL Server service was untouched throughout the FIREWALL re-configuration. We were experiencing SSPI Handshake errors and Rackspace determined that it was "related to default lifetime of the pinholes used by our firewalls of the domain controller." I doubt you want to mess with your DNS firewalls; however, that's what caused SQL Monitor to quit and upon restart immediately emitted the Backup Alerts. I certainly won't be asking Rackspace to "put things back so we can provoke a SQL Monitor problem" [image] Sorry I cannot reproduce for you. Are there any logs or the would the Monitor database itself be of any use? / comments

Reference-only = DB with "Numbers" table, "Dates" table", i.e., it has NO transactional implications whatsoever. I cannot reproduce the problem because Rackspace is responsible for the firewall con...

0 votes

Folks are adding to a User Voice thread here: http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions/suggestions/2476473-don-t-create-alias-that-map-to-other-sql-prompt-sh?ref=title Suggest anyone experiencing this BUG adds their vote to the pile so we all get a swift resolution to it... Nearly a year since this original post and it doesn't appear to be important enough to fix (maybe I'm wrong - sure hope so...) I assigned the alias crt to my CacheRefreshTrigger table in the SQL Prompt list of aliases, so it should know that I don't want a declared alias expanded! Typed AND NOT EXISTS ( SELECT 1 FROM dbo.CacheRefreshTrigger crt Resulting AND NOT EXISTS ( SELECT 1 FROM dbo.CacheRefreshTrigger CREATE TABLE ( ) Bad! / comments

Folks are adding to a User Voice thread here: http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions/suggestions/2476473-don-t-create-alias-that-map-to-other-sql-prompt-sh?ref=tit...

0 votes

Thanks to James' research and the fact that I'm only monitoring 1 SQL Cluster (would like to monitor the demo, dev, qa, and 2 spares but have no $$$), we're persisting with the product and trust that some of the simpler fixes will be available in the EAP release coming in a few weeks time. The Product has potential but needs more "relentless testing" and exposure to more real and larger environments to make the jump to kind of product many of us hoped it would be. The level of effort expended by RG Support is encouraging, so I'm not at the "wait until 3.0" stage. If you have the money, I found Spotlight on SQL Server very useful, except for the deadlocks it caused itself (really!) for 5 years on SS2000 and over a year on 2008+2000 - about 7 servers. Small potatoes to many of you full time DBAs, but for a pressed into DBA-duties SQL Developer, using both Spotlight and SQL Response (former name for SQL Monitor) gave me the graphical and educative along with the Alert-generator mix I needed to keep the servers up 99.9%+ over the 5 years. If you're willing to help Red Gate move this product on, I'm sure you'll find it a worthwhile effort - I did with SQL Compare, Data Compare, Response, Prompt, Backup... Sometimes you get out what you put in... Anyway, that's my 2-cents... / comments

Thanks to James' research and the fact that I'm only monitoring 1 SQL Cluster (would like to monitor the demo, dev, qa, and 2 spares but have no $$$), we're persisting with the product and trust th...

0 votes

Spoke to James and have emailed the zipped Base Monitor log files from Jane 20th through 24th for your analysis. Many thanks. / comments

Spoke to James and have emailed the zipped Base Monitor log files from Jane 20th through 24th for your analysis. Many thanks.

0 votes

Great idea but as others have similarly said, it's initial rendering is unusable when you have 100+ tables and 400+ SP's. How about: . Being able to 'scope' several objects then request a 'scoped diagram' of just those objects. . Taking that further, you could add additional dependent objects via right-click functionality. . A variation of that would be: select, for instance, a table, then request a dependency list (tree view perhaps) that allows the user to show/not show each dependency node. . 'Collapse' and 'expand' dependencies for one or more selected objects (placing an icon inside the original oval to show, e.g., '++' for 'dependencies present but not shown'. . Allowing us to choose a shape/shape-characteristic/color for each object type. E.g., Rectangles for tables, thick outlines/3D shadows for 'central object' visibility. Pastels are great but sometimes one needs to 'go bold'. . Definitely would like to scoot objects around with the mouse. . Diagram save with references back to the original db object id's would be great, so we could use it like the Enterprise Manager's DB Diagram (it has a memory). . Custom page breaking for printing (stretch via mouse). . Header/Footer - as simple as Excel's sheet printing may suffice to begin with. . Make the diagram scroll using scroll wheels/sticks/etc, as well as the scrolling it does now (like Google's maps, which I like). . I noticed that sometimes when I click in an 'empty' area, the selected dependency line changes - not a desirable behavior! It was about a half-inch from any line and there were lines all around the area I clicked, so the selection was at the discretion of the tool, not me... . Could you make the Legend area interactive? If I right-click on the "View" label, I'd like to be able to go to the (already suggested) filter or be able to Find a specific View and 'retain selections', 'remove from selections', 'replace selection(s)' or 'add to selections', then have the option to reposition the diagram to the latest object I clicked in the list. . If the Legend area's color box allowed us to 'X' it out, we could 'Hide' objects of the type (but retain any selections of that object type in case we want to pull objects into a scoped diagram, as mentioned above). Lessens the number of visible objects to analyze/impede analysis. Keep on bringing useful products to this market - great job so far. / comments

Great idea but as others have similarly said, it's initial rendering is unusable when you have 100+ tables and 400+ SP's. How about: . Being able to 'scope' several objects then request a 'scoped d...

0 votes

Wewe ni mpole. Shukrani nyingi kwa ajili ya anasa yako. (Courtesy of Google, Bing couldn't handle Swahili [image] ) / comments

Wewe ni mpole. Shukrani nyingi kwa ajili ya anasa yako. (Courtesy of Google, Bing couldn't handle Swahili )

0 votes

If there's something I can put in place to help you profile why displaying a "Long-running query" (LRQ) alert takes minutes, and clearing it takes minutes, and why the regular expression to exclude "EXECUTE master..sqlbackup" from popping out a LRQ Alert doesn't work, I'm more than happy to be a guinea pig... / comments

If there's something I can put in place to help you profile why displaying a "Long-running query" (LRQ) alert takes minutes, and clearing it takes minutes, and why the regular expression to exclude...

0 votes

I'm monitoring ONE SQL Cluster with only EIGHT User databases, RS and a Distribution DB and I'm between 44% and 69% when I ask SQL Monitor to do "anything" This is shocking! I wait for MINUTES to get a response and often get none, just a progress bar in the IE8 window that's stuck. The machine is a 64-bit VM with 2 x 2.26GHz CPUs and 16GB memory and the User databases are rarely referenced by a UI as this box isn't made public yet and there are only four folks who would even be on it. All that's going on is a simple every-minute suck of production data into a single table that's then materialized into an Indexed View then replicated to the Report DB - job takes 45 to 50 seconds of each minute. sqlserver is running at a VERY constant 9% to 20%. RS is barely touched and has no scheduled reports. We're moving the IIS7 website off into the DMZ but that's hardly likely to be a major impactor when the Alerting.Base.Service is sucking up so much CPU while monitoring probably the simplest cluster any reader of this post could imagine. What's Up, please? Instead of the joy of finally having "eyes on the server", I have to endure non-responsiveness all the time... I will persist with the Monitor as it's all I have and going to predecessor-brewed scripts with unintelligible-to-me output is untenable. As noted in another thread, Quest's Spotlight on SQL Enterprise doesn't have these performance issues - I agree, having been a very satisfied user of that product for over a year at my prior job and I truly wish the current Company had the funds to buy it... Sorry to be a downer, but realism is warranted. Update 1 This is crazy! I tried to clear a "Long-running query" alert and it took THREE MINUTES to change the status. I have 36 Alerts to clear - and I don't have 1.5 HOURS just to clear this piffling backlog... I threw Idera's Quick Reindex at the database that has only been on the machine for three weeks and already shows, for indexes over 2 pages with a purge setting of 1 week across the board, an AVERAGE fragmentation of 54%. The worst frag% was 99.76% on the 820 page Cluster_Machine_Network_UnstableSamples_Id_CollectionDate index, just edging out two further "UnstableSamples" indexes at 99.66% over 693 pages and 99.56% over 1,354 pages. 34 of the 88 indexes are over 75% fragmented, a further 30 are between 25% and 75% and the remaining 24 are under 25% of which 18 are under 10%. Is there a need for some "regular maintenance" on the database that Red-Gate could either incorporate as an "automatic feature" or provide as some kind of Maintenance Plan that we can leverage...? After rebuilding all 88 indexes, the average is down to 22.61% fragmented, with 8 at 75% to 87.5%, 27 between 25% and 75% and the remaining 53 under 25% of which 51 are below 10%, 39 below 1% and 18 at 0.00%. Would a tech at Red-Gate please take an interest and run some diagnostics so SQL Monitor 2.1 becomes a usable product. / comments

I'm monitoring ONE SQL Cluster with only EIGHT User databases, RS and a Distribution DB and I'm between 44% and 69% when I ask SQL Monitor to do "anything" This is shocking! I wait for MINUTES to g...

0 votes

How can we help you today?

PDinCA

Comments