Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Session with a high CPU (ms) but no waits---does that matter? Expand / Collapse
Posted Monday, July 22, 2013 11:26 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 18, 2016 1:35 PM
Points: 320, Visits: 1,594
I am using Idera's SQL diagnostic manager. It is throwing an alert saying a session has a high CPU (ms) count.

The session has been connected for over 11 hours...however, it isn't really "doing anything". (No wait time, wait types, resources, etc... and no blocking caused by the session)

We have a 3rd party application which has a database on that server. The connection is from that application back to its "meta data database". Every time an action is performed by or against this 3rd party application it has to query its meta data database to determine how to respond.

From what I can tell it is just leaving that session open because every few seconds or minutes an action is being performed.

Is there something "inherently" wrong with an application having a semi-perpetual connection like that?

(If there is a blog post or article which covers this then I would be most appreciate of a link to it so I can better educate myself)


Post #1476160
Posted Tuesday, July 23, 2013 3:44 PM

SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 4:45 AM
Points: 888, Visits: 861
Today, and it has been this way for a decade or more, applicaitons typically connect, run a query, disconnect and rely on the connection pooling the API that a reconnection will be quick. That is, the API lingers to the connection for about 60 seconds, and if there is no reconnection in this period, the API physically disconnects from SQL Server.

However, occasionally you run into application that opens a connection and keeps it open during the lifetime of the application. I may have written one or two myself. It seems that this application's connection back to the metadata database is of this old school. Right or wrong? Since I don't know anything about this application nor about the design decision I am not to judge. I know that in the system I work with, we have components that stay connected.

Erland Sommarskog, SQL Server MVP,
Post #1476815
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse