Hi,

We have a Windows Server 2008 R2 Std, with SQL Server 2008 R2 SP2 CU 0. 32GB memory and 2x2GHz 16cores.

We can see that the sqlservr.exe is taking almost all memory, and i guess that is ok since we have not configured any restrictions, and then SQL will take what it needs.

The customer has some issues with the application, it "hangs" some times, and they are wondering if its related to the SQL server. So is there any performance report or other performance files we can give to the customer so that they can show this to the application provider, because i dont think the sql server is a bootleneck.

We have not applied any cumulative updates since we have not had any spesific issues.

Thanks for reply.

Hello Andreas,

In SSMS there are some "performance reports" available: Do a right mouse click on the server node => "Reports" => "Standard reports"

You need to take a "snapshot" of the activity that is occurring on the SQL Server Instance at the time the application hangs, in order to establish whether or not there is an issue with SQL Server, specifically if there is any blocking and to identify the specific WAIT Type that is occurring on the applications session (spid), if at all.

There are a variety of DMVs you can reference in order to review performance data for a SQL Server instance. You may also wish to run an Extended Events session to capture precisely what is happening but perhaps the simplest thing to begin with would be to ask the customer to execute sp_WhoIsActice at the time they observe the issue.

This will provide you with a snapshot of the queries currently executing at that time, along with information you can use to diagnose potential issues.

Thanks for reply, im not a SQL person so im out on deep water. I downloaded a application and seems good, but could you see some performance issues here, or does it seem ok ? Or is it not good enough to tell anything ?

Thanks for reply

hm... mayby the pictures are to small...

Thanks for reply, im not a SQL person so im out on deep water. I downloaded a application and seems good, but could you see some performance issues here, or does it seem ok ? Or is it not good enough to tell anything ?

Thanks for reply

hm... mayby the pictures are to small...