SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Low Batch Requests/Sec?


Low Batch Requests/Sec?

Author
Message
brian118
brian118
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1018 Visits: 600
Hi All

System Info...
Server. 12G RAM, 2xQuad Core processors. Hard Drive C (RAID 1), Hard Drive E (RAID 10). 1G NIC
SQL Server 2008 R2. All system DBs on Drive C. 1 User DB, with Log file on Drive C and Data file on Drive E.

The application is Dynamics AX 2009 Wink

I have a report which is taking > 30mins to execute! I started the Activity Monitor and notices that the batch request/sec was about 1500-2000! with low CPU utilisation. Looking at task manager, the Network adapter (1Gb) was being utilised ~3%.

For who is not familiar with AX, the report is prossed on the AOS server (another server) and this server talks with the DB server. A lot of SQL statements are executed on the DB server and the results sent back to the AOS server which eventually will send the report back to the client.

I started suspecting the the DB server is not being fully utilised due to the low CPU utilisation and since the batch request/sec is low, it's not being hit hard enough by the AOS server. For a Gbit NIC, what network utilisation should I expect? Is there any guideline?

Regards
Brian

Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
runaldo
runaldo
Old Hand
Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)

Group: General Forum Members
Points: 356 Visits: 566
Have you looked at disk queue or memory paging?



rsorrentino
rsorrentino
Valued Member
Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)

Group: General Forum Members
Points: 69 Visits: 23
I have SQL server 2008 running on a Dell Server with 8 processors and 24 Gb RAM. Every few weeks the third party applications receives an SQL timeout issues which freezes other users. I then have to restart the server to bring it back on line. I have been running PerfMon and notice that my batch requests/sec were on average less than 10. My database is only 160 Mg and at most 25-30 user connections. Processor usage is minimal. Page life expetancy is over 300. Page splits are at time double the batch request/sec. Other performance parameters seem ok. Network connection readings are good. I set the memory max of 20 Gb and concurrent connections to 100.

Why would the system timeout? Could this be an issue regarding the programmin?
@SQLFRNDZ
@SQLFRNDZ
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2097 Visits: 1218
rsorrentino (5/2/2013)
I have SQL server 2008 running on a Dell Server with 8 processors and 24 Gb RAM. Every few weeks the third party applications receives an SQL timeout issues which freezes other users. I then have to restart the server to bring it back on line. I have been running PerfMon and notice that my batch requests/sec were on average less than 10. My database is only 160 Mg and at most 25-30 user connections. Processor usage is minimal. Page life expetancy is over 300. Page splits are at time double the batch request/sec. Other performance parameters seem ok. Network connection readings are good. I set the memory max of 20 Gb and concurrent connections to 100.

Why would the system timeout? Could this be an issue regarding the programmin?



Why do you need to configure concurrent connection setting to 100. ??

By default it will be 0 and better to leave as it is as SQL server will allow up to 32000 and more connections.


--SQLFRNDZ

rsorrentino
rsorrentino
Valued Member
Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)

Group: General Forum Members
Points: 69 Visits: 23
THe most user connecting to the server would be less than 100. I understood the limitation of changing it. My dilemma is having to restart the server every few weeks and I have been checking all the readings in perfmon. I can't tell if the server is the issue or the programming?
rsorrentino
rsorrentino
Valued Member
Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)

Group: General Forum Members
Points: 69 Visits: 23
Like i stated, the batch requests / sec is very low. Less than 10. I have checked all network, memory, and cpu readings and they appear to be ok. What else could be a server issue before I go to my programmer to rewrite some of his applications?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search