From: zmpmag3-atnis@yahoo.com   
      
   On Mon, 24 Jan 2011 08:48:59 +0000 (UTC), Erland Sommarskog  wrote:   
      
   > (zmpmag3-msql@yahoo.com) writes:   
   >> I have SQL Server 2008 "Developer Ed."  (one instance) installed on a   
   >> Win7 64bit machine. By default, it appears to place it's internal cache   
   >> files (ie *.cache) in the:   
   >>   
   >>      "C:\Users\{Sqladmin}\AppData\Local\temp\*"   
   >   
   >You mean that in this directory there are a bunch of *.cache files?   
      
   Yes.  They come named as follows:   
      
   "machine-name_instance.SQL-Server-name_{49268954-4FD4-4EB6-AA04-   
   D59D9BB5714}_#.cache"   
      
   where:	"machine-name" 				is the server's Windows computer name;   
   		"instance.SQL-Server-name"		is the MS SQL Server 2008 server and instance   
   name;   
   		"#"							is some unique 1-2 digit identifier.   
      
   In one case, the end # identifier is followed by "_QuerryActive.cache".  The   
   code between the   
   braces does change for some of the files but the one I quote above is common   
   to most of them.   
   If you like, I can send you a JPEG screen print of the directory listing to   
   your email address.  It seems   
   the file with the lowest identifer (usually "_4") is the one that grows   
   exponentially and causes the system   
   to crash.  In the past, I have been able to delete the files directly without   
   any ill effects on the engine.   
   However, they re-generate themselves automatically and keep growing. I suppose   
   I could run a script   
   that deletes them periodically, but that's not the correct approach.   
      
   >I don't know what files this might be, but I'm fairly sure that they do not   
   >come from the engine; I've never heard of such files.   
   >   
   >Possibly they are generated by SQL Server Management Studio for   
   >Intellisense, but I don't really see why.   
      
   Not running Intellisense.  I am, however, running SQL Server Agent. I have,   
   temporarily, stopped   
   SQL Server Agent and we will see if that results in a halt to the file growth.   
      
   >Have you looked inside of these files to see what's in them?   
      
   A mix of binary code and text based log information. A lot of "D O U B L E   S   
   P A C E D" text like that.   
   Again, I can send you a sample attachement to your e-mail if you like.   
      
   Thanks much.   
   ____________________________________________   
   Regards,   
      
   Arnold   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)