My ATV
-
Now this would be a cool all-terrain tool. As announced last week Dell is getting into the ruggedized notebook arena with their ATG notebook. With shock mountings, spill proof keyboard and more, it's a notebook that's designed for demanding work environments.
I've never really had issues with my notebooks (knock on wood), but I have been using my laptop more and more on the road, at Starbucks, vacation, etc. and I can't help but think that some extra protection might be nice. There's quite a premium for the notebook, but if you have had issues with notebooks, it might be worth the extra $1500.
In other news, more heavy theory from the SQL Server Programmability team. One amazing thing to me: did you know that an ALTER DATABASE SET READ_ONLY flushes the procedure cache? Same as the DBCC FREEPROCCACHE.
So answer me this, Batman. If the database is read only and the procedure cache flushes, can new plans be written to procedure cache tables?
I'm being a little silly, but it would seem to me that if I placed a DB on read only media, like a DVD, and distributed it, that I'd want the cached plans to remain there and usable for anyone querying the system. Or am I misunderstanding something here.
-
Maybe I am mistaken, but I thought that the procedure cache was an in-memory only set of data that is shared by all databases. In that case, I don't think it would get distributed on DVD media.
It makes sense to me that settting the database to read-only would flush the procedure cache, at least for that database. Once the database is in read-only mode, there is no reason for a query to aquire even read locks on objects in that database, because there is no possiblilty of the object being updated. And any plan that involved an insert, update, delete, or DDL operation would also be unusable.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply