I have a single database that takes a long time to snapshot.

tjaybelt_tjaybelt_ Posts: 6 New member
in SQL Compare
It's just a single db. the rest of the dbs on this db server are fine. This particular one takes over 5 minutes to snapshot alone. I profiled it just now, with SQL Profiler, just to be curious. It seems to process its queries in under a minute. Then profiler captures it running these 3 statements over and over.
  DBCC TRACEON(3604)
  DBCC PAGE ([SynergyLive], 1, XXXXX, 2)
  DBCC TRACEOFF(3604)
This continues for a very long time. I see in the trace that it took nearly 9 minutes. then it seems to finish out with several other quickly ran queries.

So, why does snapshot creation take so very long on this particular db? Maybe there is something wrong with it. Maybe it borked, and we don't know it.  So I'm looking at our DBCC checks to validate.
Tagged:
· Share on Twitter

Answers

  • tjaybelt_tjaybelt_ Posts: 6 New member
    I traced another database that I just traced on this same db server. and it didnt do the same long drawn out dbcc page stuff the other db does. And DBCC CheckDB shows no issues with that other db. So I'm not sure why it does that on that db and not others. 

    · Share on Twitter
  • tjaybelt_tjaybelt_ Posts: 6 New member
    More info. 
    I did a snapshot again, and unselected the options on the bottom, to not do encrypted objects, and the other. Never turned these off before. And it breezed thru. So, maybe db not pouched. 


    · Share on Twitter
Sign In or Register to comment.