SQL server database performance

Hello,

We are using teamcity 8.1.2 build 29993 running on win2k12 64bit, we were using embedded db and all was working fine. We recently moved to sql server 2012 Web 64bit the builds still work fine however teamcity seems to hog all sql server resources so other website on our server timeout. If we turn off teamcity everything starts working again. When we swap back to embedded db everything starts working as well, it seems as though teamcity with sql server is causing timeouts for other databases. Has anyone seen this before?

Regards

Ismail

2 comments
Comment actions Permalink

Hi,

Please attach thread dumps

Also, what does SQL server profiling say?

How large is your DB instance?

Did TC continue causing high DB load even after start? And how long did you wait before you shut it down?

0
Comment actions Permalink

Sergey,

Many thanks for reply, however bit a false alarm on this :8} we turned of teamcity and everything did speed up then after while started to grind to a halt, with a bit probing we found we needed more memory on the server so we increased to 12gb and everything started to run smoothly restarted teamcity and all is well.

Regards

Ismail

0

Please sign in to leave a comment.