Comments
3 comments
-
Hi Adrian,
Thanks fo the feedback. I'm afraid i can't reproduce the problem. Could you give us some information about your system, i.e. mainly machine specs? Do you think you could send us the schema of a database where it happens?
Regards,
Tilman -
This mainly happens on my larger databases which have approx 1000 objects in them.
However I just encountered this again when first connecting to the database server which connects me to the master database. It again locked management studio whilst it saved the snapshot, you should have this schema. I unfortunately can't send you our schemas as my boss said NO due to commercial sensitivity ~sorry.
My machine is a Pentium 4 ~ 3Ghz, with 1GB ram. Looking at my memory usage and the amount of virutal memory sqlwb.exe is consuming currently 256mb but I have seen this the mem usuage up at 500mb. I am suspecting now that I am low on available memory on my box. Could this be causing the problem. I am asking our tech support to see if I can upgrage my RAM to see if this alleviates the problem. I will feed back if this is the case.
Does SQL Prompt require a large amount of memory? -
Hello Adrian,
I'm afraid there's not actually terribly much we can do about this beyond decreasing the priority of the background thread used to save snapshots (it may already be set to "Lowest" in any case). In theory you should be able to carry on working whilst this is happening, however in reality we're subject to the vagaries of the Windows scheduler over which we have no control.
Sorry this is causing you problems. We'll look into it to see if we can do anything further, however in reality there may not be a resolution to this issue.
Thanks,
Bart
Add comment
Please sign in to leave a comment.
I think this mainly happens when I swap databases.
When the snapshot is being saved I would still like to be able to use the Management Studio even if this means I don't have the intellisense for that 10 seconds or so whilst the snapshot is being saved.
Adrian