5b182c79   
   From: esquel@sommarskog.se   
      
   xo (xo5555ox@gmail.com) writes:   
   > Besides the default SQL 2005 trace comes with the box, I enabled SQL   
   > profiler tracing with a stored procedure.  And the trace files size   
   > was set to 25GB; however, I noticed the trace has been terminated when   
   > it hit 4GB and shouted out error in sql server log that there is not   
   > enough space on the disk and restart the trace after correcting the   
   > problem. but my drive still have 86GB free space.   
   >   
   > Are there something else set the file size limit besides what's the   
   > book online mentioned an upper limit of 1 gigabyte (GB) for the   
   > maximum file size option and default maximum file size is 5 megabytes   
   > (MB)?   
      
   So you started a trace from Profiler, and asked for to be saved to disk?   
   That's not a good idea. Profiler is good for short monitoring, but longer   
   traces you should run server-side. These are actually not difficult to   
   set up. Use Profiler, and you might try for a short while to see that   
   they look good. Then you can select the Export option from the File menu   
   to get a script. In the script you can set the maximum file size.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)