SQL 2000 Query image now Slow was Quick!

[bigdavelamb]

Hi

I am returning data from a SQL table with five fields one of them is an IMAGE of about 400kb, this used to return quickly however over the last couple of weeks it now takes over a minute to return, I ran the SQL Profiler and it confirms this, does anyone have any ideas why the same query could suddenly dramatically slow down so much? Here is the Profiler line (the last two fields are the Start and End time for the query).

SQL:BatchCompleted select * from badgetemplates where badgeid=39 .Net SqlClient Data Provider door2 VELOCITY\door2 0 1592(Reads) 0 88576(duration) 0 58 2008-01-10 14:28:05.640 2008-01-10 14:29:34.217

Thank you.
Dave

 

[SQLDenis]

>>does anyone have any ideas why the same query could suddenly dramatically slow down so much

usual culprits

statistics not up to date
table fragmented
problem with the disk IO subsystem

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[bigdavelamb]

Thank you for the prompt response much appreciated, when I return data from a different record that has an even smaller image, it return very quickly......

 

[SQLDenis]

network problems?

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[bigdavelamb]

I don't think so as i was running a ping whilst getting the data under it was all Ok and under 1ms!