Log in

No account? Create an account
Sarah's Blog [entries|archive|friends|userinfo]

[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

February 28th, 2009

Database admin help! Mysterious slowdown! [Feb. 28th, 2009|09:44 am]
We've got an MS "SQL Server" that gets lots of queries every minute, some take a few seconds.

Recently we've had a mysterious slowdown. It happens perhaps once a week, the time it starts is random.

The SQL queries start taking ages, over 5 minutes and above! The SQL process is at 100% (no other software is slowing it down).
Everything becomes unusable!

The only way to cure the problem is to stop the SQL service, and start it again.

I wonder if this is caused by the number of SQL queries coming in reaching a tipping point where the server can't keep up, and the queue of queries builds up massively?

Is there any way I can check for this? Or is the problem something entirely different?

Any ideas are welcome. =D
link4 comments|post comment

Octopuses, Octopodes, but not Octopi. [Feb. 28th, 2009|09:45 pm]
In one instance, an octopus given a slightly spoiled shrimp stuffed it down the drain while maintaining eye contact with its keeper, Linden said.

1758, genus name of a type of eight-armed cephalopod mollusks, from Gk. oktopous "eight-footed," from okto "eight" (see eight) + pous "foot." Proper plural is octopodes, though octopuses probably works better in English. Octopi is from mistaken assumption that -us is the L. noun ending that takes -i in plural.

link1 comment|post comment

[ viewing | February 28th, 2009 ]
[ go | Previous Day|Next Day ]