Posts
Sort by recent activity
What's the best way to get SQLServer:Access Methods:Forwarded Records/sec?
SQL Monitor 10.0.8We have a vendor ERP DB (Deltek Vision) that uses heaps...everywhere. I was a little surprised to not find SQLServer:Access Methods:Forwarded Records/sec in the stock metrics in ...
Best RG option for simple DB dev
I've struggled with implementing SCA with a complex (>6000 programmable objects, >800 tables) vendor DB that our BI team adds objects to (e.g. views, sprocs, etc.). Main issues have been:1) # of o...
"Unauthorized" when attempting to add a VMWarte host to SQL Monitor
SQL Monitor 9.2.14I'm unable to add a VMWare host to SQL Monitor. When I do, I get "Unauthorized". I have verified that I can access the vsphere web client via https using the read-only credentia...
Change schedule for fragmented indexes check for single SQL Server instance?
SQL Monitor 9.2.0.23782I rebuild indexes on one of our SQL Server instances on Wednesday nights. I'd like the SQL Monitor fragmented index check to occur after that - for that server only. I have...
For TOP 10 Queries, where can we find the host and SPID/session_id of the connection?
SQL Monitor 9.2.0.23782.I'm looking at one of the TOP 10 Queries. I'm wondering where I can find the query's connection's host and SPID? I's also not seeing when the query started and finished. ...
Why are all programmable objects deploying (deploy) to a target DB that is already baselined?
I made a SCA project with a baseline from our prod DB which has >6000 programmable objects. I made a couple of minor migrations, and now I'm using the powershell cmdlets to validate the build, mak...
Refresh fails due to incorrect compatibility level in shadow DB
SCA: 4.2.20023.15120VS 2019: 16.4.3I have the project set for target platform "SQL Server 2008", which should be compatibility level 100. However, when I "Refresh" the project, it builds a shadow ...
SCA in SSMS add-in mostly "(Not Responding)"
My first attempt at using SCA SSMA add-in is not going very smoothly. (I have used SCA in VS for a couple of years). I have the latest SSMS 18.4 and the latest SQL toolbelt (DL'd and installed to...
How to exclude SQL Error Log alerts for certain errors and clients?
Apparently, our network admins use a port vulnerability scanner that causes a variety SQL Server Error Log errors. With the default settings, these fired SQL Monitor alerts, which sent a flood of ...
Option to NOT drop column in target table?
I have the unfortunate case where both the source and target tables may contain new columns. I want to effectively "merge" the two. I was hoping to sync one way, then the other. I am not seeing ...