Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 .

share|improve this question

3 Answers 3

Profile an insertion and get the query execution plan.

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

share|improve this answer

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.

share|improve this answer

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.