3
votes
1answer
25 views

SQL Server 2005 global slowdown

Two days ago our production server suffered a massive slowdown where the primary symptom was that an extraordinarily high number of requests were suffering SQLTimeouts. I will quickly describe our ...
2
votes
1answer
286 views

SQL Server 2000 HIGH CPU Usage with BusinessObjects reports (unsolvable?)

I have one of those weird questions, those ones that are nearly unsolvable (the only way to really solve them is to throw out the technology and buy new ones). I've had a number of experts (about 10 ...
1
vote
2answers
44 views

Store TIME in SQL

What is the correct way to store the TIME of day in SQL? Have a field that cares only when an action took place. Example values will be 2:30 PM or 14:30, it doesn't matter to me which. This ...
0
votes
1answer
67 views

SQL 2008 Performance Reports

Does anybody know of DMV's or reports that will show the historical performance of the stored procedures on the server? Also if that data is stored in a table or tables, what is the retention period ...