We have a client with a SQL Server 2005 installation that has started
thrashing the CPU.
The server houses a BizTalk installation and a database for a mobile
application.
The thrashing seems to be continuous and just started today - no changes
have been made.
Synchronisation to the mobile devices has gone from about a minute to
anywhere from 10 to 50 minutes.
The BizTalk tasks continue to run and don't appear to be slowing down at
least no significantly. Admittedly one of the BizTalk orchestrations creates
a lot of deadlocks as it gets fed a bunch of files at one time and then tries
to process them all at once. I think there is some fine tuning to do here but
don't believe it is the problem as the cpu is still thrashing when the
biztalk tasks have completed.
The task manager show SQL Server as the one using all of the CPU, but I am
not sure how to find out what is the actual cause of this.
Perhaps it is something to do with replication. I really am not sure where
to look now.
I have veiwed the activity monitor and seen the "blocks" create by the
BizTalk orchestration mentioned above, but these do go away as BizTak or
rather SQL creates deadlock victims.
I wonder could the Biztalk clenaup tasks be getting out of control.
Any ideas or more information required
A little bit about the setup
2 x 3.4 ghz xeon
3.25 Gb ram
Win2k3
SQLServer 2K5
One drive (physical) for OS
One drive (physical) for logs
One drive (logical on a SAN) for data
This is the first application to be set up on this server so there is
supposed to be nothing else running
TIA
Steve
SQL Server Thrashing CPU
Hot Topic
- EXECUTE permission denied on object 'sp_dts_getpackage'
- Transactional LOB replication error
- Install SQL Server2005 Error:[Native Client]Encryption not supported on the client
- how can I add a unique key column to a table and generate its values automatically?
- Connection managers - OLE DB
- How do you process AS objects from the command-line?
- Error creating new SSIS project
- URL Access using Impersonation
- reset toolbox doesn't delete my components
- Troubles with XML Bulk Load
SQL Server
- A native exception occurred: synchronizing data between the MS SQL Server database and PDA
- SQL Login failed
- CreateProcessAsUser in SQLCLR
- import tool
- Transform sql server mobile edition database to sqlce2.0 format.
- what is the meaning of "64(error not found)" in sys.transmission_queue
- Problem connecting to SQL Server 2005 database instance
- How to limit the time Dimension to 24 months
- Can't create SSIS project in BIDS on workstation with Client tools only installed
- Want Hyperlink to Open in a New Window
SQL Server Thrashing CPU
Tom Archer - MSFT
A lot of them can synchronise fine and only a few seem to be having trouble.
I am in the process of looking at the database maintenance and indexing in order to ensure that they are not part of the issue
Any other tips greatly appreciated.