Hi Frederico,

No problem at all.  Thanks for the detailled information. i will pass it to the developpers and see what they can do.

Thanks again.

Hi Frederico,

Did you see anything unusual in the query or the explain plan ?

Thanks for the update.

Hi Frederico,

I have uploaded the query and the explain plan.

https://www.brentozar.com/pastetheplan/?id=r109LVnjs

Hi Jo,

i followed the instructions en tests in your link: https://www.mssqltips.com/sqlservertip/4939/how-to-force-a-parallel-execution-plan-in-sql-server-2016/

If we run the query and we look at the execution plan it stays in "single serial" mode. ...

In reponse to Jo

I agree with Jeff, the applications seems to use a single connection sequentially.

So if i understand correctly, within the software, when they launch a query, the would...

Update.

The thirdparty company which provides the software. Has looked into the reports of Brent Ozar sp_Blitz and adjusted all the recommedations within the SQL/SQLsoftware. Great. See what influence this has.

They...

new upload

Under the item Parallelism, i have the following settings:

Cost threshold for parallelism = 50

Locks = 0

Max degree of parallelism = 8

Query wait = -1

Note: This is the MAXDOP from the...

OK all users are back to work.  And still complaining about "speed" or the lack of it. As in the previous comments we adjusted all the tips and tricks we recieved....

Next week they are returning from holiday and everyone will start working again. The SQL app will go to full use again. So then we will see what the effect...

additional (usefull??):

we did some testing with the virtual machine where the sql resides.

First we had 4 vprocessors,  If we run the sql app and start working with it, we noticed...

Hi Michael,

Thanks for the extensive feedback.

My fault, i should have cut the admin fields. Good remark. In the heat of the speed 🙂  My intention for next year take some...

retry in word format

In the meanwhile i had the possibility to run the sp_blitz. (not under real-life-load)

The result are in attachment.  Curious if that output will show something to you SQL-guys.

Thanks for the...

Hi Frederico,

Thanks for the tips. I did the following adjustements.

Server 2016 OS

Power settings -> all on max.power -> was OK

Smart array raid controller

Power settings -> Max performance -> was OK

HP...