On Tue, 25 Jan 2011 00:02:22 +0100, Erland Sommarskog    
   wrote:   
      
   >mag3 (zmpmag3-atnis@yahoo.com) writes:   
   >> On Mon, 24 Jan 2011 08:48:59 +0000 (UTC), Erland Sommarskog   
   > wrote:   
   >> Yes.  They come named as follows:   
   >>   
   >> "machine-name_instance.SQL-Server-name_{49268954-4FD4-4EB6-AA04-   
   >> CD59D9BB5714}_#.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".   
   >   
   >Does not ring a bell. For this reason I posted question to our internal   
   >MVP forum. The only suggestion this far is that it may be related to   
   >FILESTREAM, but he wasn't sure. Do you use FILESTREAM?   
      
   Yes, but I have no active instances of it at present.   
      
   This definitely seems to be "SQL Server Agent" related. When I turn SQL Server   
   Agent off,   
   the .cache files stop accumulating data. When I start it again, they start   
   accumulating again.   
   I also tested this by leaving SSMS on/off as well, and that has no affect at   
   all on the results.   
   It is the "_4.cache" file that seems to accumulate the most data. I will send   
   you JPEG screens   
   of my SSMS home page (with SQL Server Agent tree items expanded), as well as   
   the screen   
   of the */temp directory where these .cache files are accumulating. I'll send   
   these via e-mail.   
   I would send you a copy of the "_4.cache" file but it's too big now, and   
   contains too much P.I.I. :-)   
      
      
   Thanks much.  I just want to be able to specify a different directory in which   
   these .cache files   
   can accumulate.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)