[dba-SQLServer] sql performance monitoring

[J- P]

it doesn't stop automatically , what I was trying to convey is that once  the Access front end starts "crapping out"  the only immediate remedy is restarting the  SQL instance.







Jean-Paul Natola



________________________________
From: dba-SQLServer <dba-sqlserver-bounces at databaseadvisors.com> on behalf of Jim Lawrence <accessd at shaw.ca>
Sent: Wednesday, April 25, 2018 12:58 PM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] sql performance monitoring

Why does the SQL service stop?

Jim

----- 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
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com