1

At some costumer we have a really slow insertion to the database (three time slower then normal). I cannot see the reason why it happening. Checked the network and it seems to be ok.

Any suggestions what can be wrong with the db here ? and how i can check it ?

We are using sql server 2005.

thanks .

3 Answers 3

1

I would suggest using a combination of perfmon and sql profiler could help you identify the issues.

Perfmon can use a series of SQL specific monitors per the microsoft technet But I'd also suggest looking at your disk performance, not to mention looking into the sql specific performance using DBCC per a few resources out there.

1

Sounds like you have an issue with storage at that client. IO is one of the biggest contributing factors to SQL Server performance (or lack thereof). What is your storage configuration at that client?

Have a look through these articles. There are also a ton more with regards to storage configuration best practices for SQL Server.

1

Profile an insertion and get the query execution plan.

Might be updating running triggers, or updating excessive number of indexes.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .