Here at SQL Sentry, we have spent much of the last decade creating software to make life better for data professionals around the world. We are proud of the software we have created, and we continue to enhance it on a daily basis. We pride ourselves on creating more than just basic features that do the minimum. When we design functionality into our products, we do our best to consider all the possibilities and use cases our customers might need. We balance this with "ease of use" - so users with less experience can still get to the root of their problems and solve them quickly.
However, we believe a lot of our users only scratch the surface of things that can be done, or they may not realize what is even available. We discovered it can be fun to hear these tips and tricks from our users, so we're turning it into a contest! Starting today, through March 14th, we want you to send us your best "#TipTuesday" tips and tricks. We will pick one or two each Tuesday to showcase, then on March 15th we will run a poll of the top 5 to let everyone vote on the most useful submission. The winner will receive a $250 Visa gift card!
To get you started, here are a couple handy tips you may not know about:
Scan For Configuration Changes
Have you made a change in your environment and you're not seeing it where you expect to? Depending on the type of change you make, our service won't pick it up until the next time a scheduled poll is made. The polling interval varies, depending on the potential frequency of the type of change you are making. The reason for this is because the schema syncs are more expensive than other collections, so we don’t want to do them constantly. This effectively reduces the load on monitored servers. For example, if you create a new database, it will not show up on the Disk Activity tab of the dashboard for up to an hour. However, you can make it happen sooner by performing a Scan For Configuration Changes from the context menu of the affected Target.
Highlighting Related Events
The calendar provides several options for grouping events. Right-clicking an event and selecting "Highlight" will display the applicable highlighting options for the event. Once the highlight options are chosen, similar events to the one selected will be highlighted on the calendar. The selected elements will be persisted for all identical event sources across the installation. If the instance is also monitored with Performance Advisor, using the Jump To Dashboard feature will overlay each of the selected events on the Performance Advisor Dashboard.
Just retweet our #TipTuesday contest tweet, and then e-mail your favorite tip or trick for Event Manager, Performance Advisor, Fragmentation Manager, or Plan Explorer to email@example.com (please include screen shots if possible, and put #TipTuesday in the subject line) and not only will you be helping out your fellow SQL Sentry users, but you could walk away with $250! How Cool is That?