Activity overview
Latest activity by tjaybelt_
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. / comments
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.
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. / comments
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. ...
I have a single database that takes a long time to snapshot.
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 ...