The most recent content from our members.
Folks, My existing Solarwinds Orion 2022 Primary Polling Engine & SQL Server 2019 Standard has been configured and installed by my predecessor as a single Azure VM ( 1 socket 8 cores & 32 GB vRAM) * May I know the best practice in deploying the Primary Polling Engines in Azure as VM? * Can the SQL Database recoverability…
Hi People, Using the Solarwinds Orion Platform with SAM, VMAN, SRM and DPA integrated feature with PerfStack dashboard https://www.solarwinds.com/perfstack Can someone here please share what alert metrics that I need to monitor for SQL Server HA Cluster nodes? The SQL Server VMs MSCS Cluster is running on VMware vSphere.…
Time flies when you were having fun, so I must be having a blast because Database Performance Analyzer 10.2 has arrived in a blink of an eye (just 6 months since 10.1). If you are ready, you can download it from the customer portal and for free evaluation from the SolarWinds Website. Be prepared to save hours every day as…
Description This alert is for SQL Server instances only and will tell you when SQL statements have executed more than a defined amount of time. This example uses a 300 second threshold, meaning any SQL statements that have been executing for longer than 300 seconds (5 minutes) will be alerted. The alert query executes…
Since SolarWinds acquisition of Confio back in October 2013, customers have asked about the differences between Server & Application Monitor AppInsight for SQL and Database Performance Analyzer (formerly Confio Ignite). Although both products monitor SQL Servers, their purposes are unique and different, two sides of the…
I hunted around a while but couldn't find this in the KB or elsewhere.
Recently I've had a several people ask me for advice on getting started with managing their networks and so I thought I'd take a few minutes tonight to shed some light on the subject... Now, this might seem like an odd topic as many of us have been neck deep in network management since we were knee-high to a grasshopper,…
It's hard to imagine a company today that doesn't rely heavily on Windows Server based applications. Sure, a lot of us have some Linux based apps, apps delivered via SaaS, and probably even some apps in the cloud where we're not 100% sure what they're running on; but chances are that you rely on Microsoft Exchange for…
I took some time this week to update my list of not-so-common metrics that I find useful when monitoring for performance. With SQL Server 2014 having been released recently, it was as good a time as any to make the updates. You can see details about the metrics and my thoughts behind each one here:…
What is Index Fragmentation? SQL server has indexes for organizing data within the database. Having a clean index helps you perform SQL operations efficiently. When you modify or update the data in your SQL server, the index content scatter. This scatter is what’s referred to as index fragmentation. Why does it occur?…
It looks like you're new here. Sign in or register to get started.