Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ebhlive
Starting Member
4 Posts |
 Posted - 2008-02-14 : 13:14:54
|
| Hi, I work for a website and we've been experiencing some problems as of last on our db server (most noticeably from a 3rd party app we installed that uses sql server). In any case, some things outside of this new app have all of a sudden started to perform slowly sporadically. The sps are nothing to write home about, and they're nothing that say - a mixing index can help. And for the most part or usually quite fast. Example - a very simple sp that is only doing Insert into TABLE NAME values(....) took 8 seconds yesterday at 4pm. Normally less than a millisecond. I'm having a hard time trying to figure out what I should be looking at since I believe other resources are the cause. Any help would be great.thanks. |
|
|
jdaman
Constraint Violating Yak Guru
354 Posts |
Posted - 2008-02-14 : 13:17:46
|
| Did you install the 3rd party app on the same box as sql server is installed? |
 |
|
|
ebhlive
Starting Member
4 Posts |
Posted - 2008-02-14 : 13:44:14
|
| no. the app itself is on our webservers. db server cpuusage average is under 40% |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 00:46:31
|
| How often do you rebuils index or update statistics? |
|
|
|
MuadDBA
628 Posts |
Posted - 2008-02-19 : 12:35:39
|
| I don't tink that indexes or stats are causign some of the problems he is describing (not to say it is not helpful to make sure you keep your i ndexes and stats healthy). It hink it ms more likely that he is having resource conflicts of some sort. Start small, by using SQL profiler. I suspect something (perhaps a large insert or tablescan) is blocking your process from completing. |
|
|
|
|
|
|
performance