Home extremely slow table operations on a table with few rows but large column contents
Reply: 1

extremely slow table operations on a table with few rows but large column contents

John Sheridan
1#
John Sheridan Published in 2017-11-14 00:35:29Z

I have a table with only 9 rows and 10 columns. Three of these columns are VarBinary and contain about 12-30 MB of data in each column for each row. Now even simple updating of one row takes more than 20 minutes and Sql times out. Even a select statement takes about 40 seconds unless I excluded the Varbinary columns from the query

Any suggestions. Thanks

JM_
2#
JM_ Reply to 2017-11-14 23:12:50Z

20 minutes to update sure sounds like either a network or IO bottleneck. Have you looked at your wait stats for things like PAGEIOLATCH_* waits? This article is a good reference for running a performance monitor to see if your subsystem is having issues: https://blogs.msdn.microsoft.com/sqljourney/2013/06/03/how-to-troubleshooting-sql-server-io-bottlenecks/

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.313468 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO