[dba-SQLServer] sql performance monitoring

Jim Lawrence accessd at shaw.ca
Wed Apr 25 15:32:13 CDT 2018


Just a note, and this observation is at least a decade old; UDFs seemed to slow down performance and for that reason, at one point, I never used them. OTOH, newer version of MS SQL may have optimized these functions by loading them in memory. Oracle had that feature where an admin person could choose to keep certain functions loaded in memory or just make them sticky...

Jim 

----- Original Message -----
From: "Arthur Fuller" gmail.com>
To: "Discussion concerning MS SQL Server" databaseadvisors.com>
Sent: Wednesday, April 25, 2018 10:11:16 AM
Subject: Re: [dba-SQLServer] sql performance monitoring

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.

A.
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


More information about the dba-SQLServer mailing list