[dba-SQLServer] sql performance monitoring

Jim Lawrence accessd at shaw.ca
Wed Apr 25 11:58:50 CDT 2018

Why does the SQL service stop?


----- Original Message -----
From: "J- P" <jnatola at hotmail.com>
To: "Discussion concerning MS SQL Server" <dba-sqlserver at databaseadvisors.com>
Sent: Tuesday, April 24, 2018 4:53:06 PM
Subject: Re: [dba-SQLServer] sql performance monitoring

Correct, Access functions-  one thing i have always noted even when it was on the physical server is that the when ever  you open any job , for example "Joe Blow reception "

You open the job and lets say i want to print/preview proposal, or what equipment is going on the job- ALWAYS at the bottom of the screen in access it says "calculating..................." then it opens- 5,10 even 15 seconds on the average- when things get bad it can take 20-30 or more, or it will crash Access completely -

That's when I get the infamous email or text "Access is acting up" or "We can't work"  then I login , or tell them to login to the server and  "restart the sql service"  then everything returns to normal , at least  by there standards

And when i login the server (before restarting it ) sql maybe at 2gb cpu at like 5%

The hyperv disk is Fixed VHDX

Jean-Paul Natola

From: dba-SQLServer <dba-sqlserver-bounces at databaseadvisors.com> on behalf of fhtapia at gmail.com <fhtapia at gmail.com>
Sent: Tuesday, April 24, 2018 5:24 PM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] sql performance monitoring

dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list