edzdbservices

Would be great to have all the flexibility that you have when scheduling a job in SQL Server. Use case - I want a wait time alert to run only when the staff is present - 7AM to 6 PM Mon - Sat. If in the middle of the night the wait times go up, they inconvenience no one and I don't want to be woken up then by a text…

Thanks, mandevil. I've been working along those lines, but I always try to avoid actual SQL Server cursors as they can be unreliable and slow, so I loop thru in a different manner. Here's what I have so far that works well in my repository. IF (SELECT COUNT(*) FROM SYS.OBJECTS WHERE NAME LIKE 'TopPlanAdviceAllServers') = 1…

I created a Solarwinds ticket and working with the tech support dude we did this process and it worked. My tech support rep was very helpful. One important warning, however! Looking for tables with names like '%_26' found all the right tables PLUS 4 tables for _226 !! Don't delete those! I believe that is because the…

Hello and thanks again for your quick response. I did as requested - select id, name from ignite.COND /* found that one of the instances had an ID of 26 in the COND table. */ SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%_26' /* this found 64 tables with table_name like _26. */ So before I go crazy and…

That gets me very close to what I want, but for a single instance - thank you! I may post a script that takes it the rest of the way to a single output for all servers - we'll see if that is as easy to do as I hope it is.

Scroll to the right to see where Options resides in the first screenshot.

I tried to register one of the existing servers and the error message is This database instance is already registered in this Repository So at one level, the instance is registered, but at the level where I need to unregister it, it is not registered/not on the list of instances that I can unregister. This is getting…

Thanks for letting me know. We will be upgrading at some point and this gives added motivation.

You can also CLEAN_DAYS_OF_TREND. By default DPA keeps 5 years of trend data (1,825 days). That's great for your most critical servers, but maybe you don't need that much data for staging or dev servers or servers where you aren't likely to do extensive research into the past. Save some space if you've been tracking trend…

SQL Server

Mandevil, thanks for the response but that does not work in this case. These instances are listed in License Management but are not registered, so when I go to the Unregister page they are not listed and there is nothing for me to do on that page. What you suggested would work well with a currently registered instance, but…

Here's another option. How many users are you interested in showing? You can show more than 10 or 15 users on a chart by using the Advanced Options. And that way you have the nice colored graph to show management - most managers love colorful charts because they can tell the impact at a glance that way. To show more than…

I also use X-Windows fairly often and adding this feature would make Solar-Putty my go-to SSH all the time. In particular, I use Xming with regular Putty to run X-Windows programs.

I understand your desire to list the database name for instances with many databases on them and could use it as well. I found that in the const_<DBID> table there was a pname field (proc name?) which would start out with a database name. I added that to the code in a field I call DB_clue and I also added an instance name…

If you aren't familiar with sending text messages via email, here is a web page with a chart for the various carriers - you might find it useful. http://www.digitaltrends.com/mobile/how-to-send-e-mail-to-sms-text/ We have been doing this for years. Sometimes the text message will be delayed beyond how long an email takes…