The most recent content from our members.
Hello, I have recently started using SAM (and especially AppInsight) to complement the monitoring of SQL instances that we do with Database Performance Analyser. One resource that I would like to add to a view is a list of failed SQL agent job for all SQL instances that have the AppInsight template applied to. I know I can…
It seems like every organization is looking at what can be moved—or should be moved—to the cloud. However, the cloud is clearly not for everything; as with any technology there are benefits and tradeoffs. As such, it is important for all IT professionals to understand when and how the cloud is advantageous for their…
You sit down at your desk. It's 9:10AM and your coffee is still warm. There is a smell of bacon in the air. Suddenly your phone rings. The trading system is down. The time for quick thinking is now. Where would you begin to troubleshoot this scenario? A lot of people will reach for the biggest hammer they can find: a tool…
Hey folks, first time poster here, so please forgive any newbie errors contained herein. Feel free to flame accordingly. We're using a variety of SW products on a SQL Server 2008 back end. Our general process around database administration tasks is to run Update statistics daily if possible, weekly on the more sleepy…
I've technically got a two part question here and I'm pretty new to Syslog in general. Our Kiwi Syslog server forwards it's logs to a SQL Server and I've got to bring the SQL Server down for a consistency repair that I can't fix offline at the moment. Here's my questions. 1. Will the Syslog buffer store messages that it's…
Hey Everybody, I'm starting work in an environment that enforces rigid security so they probably won't just give me all the passwords like I deserve :-) We're planning on replacing an existing SolarWinds installation with an expanded new one. The existing installation is configured with many SNMP, WMI, VMware and Cisco…
Hi folks, I recently stumbled upon a query whilst analyzing our database. I ended up making some tweaks to the underlining index taking it from 2000+ reads to 8 reads, speeding up the query significantly (it's a high execution stored procedure). Now when I look at the historical trend chart for this stored procedure it's…
In SAM 6.1.0, the reporting of the last database backup does not take into account the backup type. See the attached images, one for a database in simple recovery that only has full database backups, and the other in full recovery mode that has both full and transaction log backups. Without the backup type it is not…
I was provided access to a client's Solarwind environment to test out using it to monitor SQL Server. I started out reviewing the mentioned template and most of what I see on this forum are questions that end up with complaints on why "this or that". My question is how do I see the full component monitor to see what it is…
It looks like you're new here. Sign in or register to get started.