[dba-SQLServer] sql performance monitoring
fuller.artful at gmail.com
Wed Apr 25 12:11:16 CDT 2018
One other thing concerning Access functions, including UDFs. Many Access
functions have SQL equivalents, and most UDFs can be ported to SQL.
Performance gains may not be dramatic regarding UDFs, however.
Also, has it been considered that the big problem might be the VM? It might
be useful to experiment with a dedicated server rather than a VM, on a
weekend or sometime when nobody's using the system. Hardware is so
inexpensive now that the performance penalty incurred by the VM software
may not be worth it.
More information about the dba-SQLServer