[dba-SQLServer] sql performance monitoring

[J- P]

it ran just as crappy when it was physical as well- granted it was much older hardware-


I just feel that the standard 5-to 15 seconds waiting on "calculating" or the 10-20 seconds waiting on "running query" on the front end suggests poor "coding" for lack of a better term and when running from RDS its even worse-  After all were only talking about ~2gb DB and ~40mb Access f/e and AT MOST 20-30 concurrent users





________________________________
From: dba-SQLServer <dba-sqlserver-bounces at databaseadvisors.com> on behalf of Arthur Fuller <fuller.artful at gmail.com>
Sent: Wednesday, April 25, 2018 1:11 PM
To: Discussion concerning MS SQL Server
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