Slow Batch Process

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Slow Batch Process

Slow Batch Process

Rate Topic

Display Mode

Topic Options

Author

Message

Degradable

Posted Wednesday, January 09, 2013 2:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 8:43 AM
Points: 5, Visits: 56

Windows 2008 R2 Server VM on Hyper-V host
SQL 2008 R2
RAID 1 Array for Log (Seperate physical spindles)
RAID 10 Array for Database (Seperate physical spindles)
Raid 10 for OS (Shared with other VM)

New Database migration of Navision proprietary database to MS SQL. I do not have access to CodeUnits on the client (Dynamics 2009).
Most functions and processes run within accetable limits, (Some very much faster). But overnight batch replenishment routines run very slow. In the order of 3 times slower than a simple Laptop with single disk.
My issue, is I am not able to see what is causing the issues. If I use perfmon, I am not aware of any issues that point to performance being the limiter, indeeed at times it appears to be the opposite. If I use profiler with TSQL template I see masses of CursorFetch, and a few parameters, but other than 20% CPU I see no real activity within the rest of the IO structure of the system. What is going on is hidden from my view.....

I would appreciate assistance and guidance on trying to find / analyse what is the cause. Obviously this is exposing my SQL limitations for fault finding and I could do with a nudge in the right direction.
Any assistance appreciated in advance

Post #1404623

« Prev Topic | Next Topic »

Permissions