The most recent content from our members.
Hi All we have SQL 2016 for our backend and we have appinsight for SQL monitoring it. All seems to be good, except the deadlocks/sec is always above 0, usually 0.10 Are there anything we should be looking at in order to sort out this issue? Everything else seems to be OK. I'm wondering if there are some standard processes…
Hi Guys .... We have been using Solarwinds for our company for many years now. Its been running on Windows Server 2008 with SQL Express. I'm now planning to move away from that old system and Install Solarwinds on a dedicated Windows Server 2016 . Where the Microsoft SQL Server will be installed on its own dedicated server…
We have a custom SQL query on availability we have been running for years for a client with 145 locations. It use to run in a matter of seconds till we upgraded to NPM 12.4 and SQL server 2016 SP2. Now the query runs for hours for more than 10 nodes. It will run in 4 seconds for 10 nodes or less. I have included the query…
Anyone can share the requirements for Orion SQL as PaaS for multi module.
I would like to trigger custom job in solarwind that would do back up on certain time when it received configuration change syslog message from node. For example , I changed config on node at 3 :00 PM and it would do back up immediately or after midnight 1 : 00 AM. is this possible ? I am also thinking ,is it possible in…
Hi all Am I right in saying that SQL 2016 all service packs and cumulative updates are supported WRT using it for the Database for Orion?
Please Help!!! According to Upgrade and Migration Guide, I have to migrate the Engine and SQL servers to Windows 2016 and minimum SQL server 2016. Current Config SAM 6.4 NCM 7.6 NPM 12.1 NTA 4.2 Existing Servers Engine Windows 2008 R2 Database Server Windows 2012 SQL Database 2014 New Servers Engine Windows 2016 Database…
Hi We have some alerts set up on things like Batch Requests/second User connections PageLife Expectancy etc We have certain KPI values for each one and the alerts trigger when the value is over the KPI. This then writes to a file, which we load each day into a SQL database and report on them fortnightly. These alerts check…
Since upgrading to NTA 4.4 and pointing NTA to a new database on our MS-SQL server about a week ago, the SQL Service has crash dumped twice with a Deadlocked Scheduler error. We started over from scratch and did not attempt to migrate any data from 4.2 database. The SQL server is a beast and rarely breaks 25% CPU and 30%…
I am currently evaluating setting up database monitoring for Solarwinds LEM and the instructions advise me to import a profiler template and then edit this template. I am using SQL Server 2016. When I import the template and select edit, I can see the imported template but ONLY when I select SQL Server 2014 as my SQL…
It looks like you're new here. Sign in or register to get started.