|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
sql profiler writing on an unused partition?hi,
i am running sql server 2005 profiler on a system, where not much space is left on c:\. that way i have configured profiler to write all files on d:\, which is more suitable here. however i clearly can see that c: is somehow affected as space is getting less and less here. as soon as the profiler is stopped and restarted - space is facing the same size as in the beginning on c:\. i am wondering, why it is like this in order to "disable" it. errorlog is facing the same size; the same for eventlogs... -- thanks in advance / danke im voraus, fritz -- Fritz Theiss Are you sure that the problem is SQL Profiler? How do you create the trace
files (with sp_trace_create or maybe Profiler is running?) Show quoteHide quote "Fritz Theiss" wrote: > hi, > > i am running sql server 2005 profiler on a system, where not much space is > left on c:\. that way i have configured profiler to write all files on d:\, > which is more suitable here. however i clearly can see that c: is somehow > affected as space is getting less and less here. as soon as the profiler is > stopped and restarted - space is facing the same size as in the beginning on > c:\. > > i am wondering, why it is like this in order to "disable" it. errorlog is > facing the same size; the same for eventlogs... > > -- > thanks in advance / danke im voraus, fritz > -- > Fritz Theiss > thx so far.
to answer the questions: 1) well, i do run sql profiler, nothing with sp_trace_create. 2) yes, i am sure - as soon as profiler is stopped, space on c:\ gets freed. -- Show quoteHide quotethanks in advance / danke im voraus, fritz -- Fritz Theiss "Carlos Sacristan" wrote: > > Are you sure that the problem is SQL Profiler? How do you create the trace > files (with sp_trace_create or maybe Profiler is running?) > > > -- > -- > Un saludo > ------------------------------- > www.navento.com > Servicios de Localización GPS > > > "Fritz Theiss" wrote: > > > hi, > > > > i am running sql server 2005 profiler on a system, where not much space is > > left on c:\. that way i have configured profiler to write all files on d:\, > > which is more suitable here. however i clearly can see that c: is somehow > > affected as space is getting less and less here. as soon as the profiler is > > stopped and restarted - space is facing the same size as in the beginning on > > c:\. > > > > i am wondering, why it is like this in order to "disable" it. errorlog is > > facing the same size; the same for eventlogs... > > > > -- > > thanks in advance / danke im voraus, fritz > > -- > > Fritz Theiss > > > 1) well, i do run sql profiler, nothing with sp_trace_create. OMHO, you *should* use a server side trace and manage with the sp_trace_* stored procedures if you have a lot of data being traced. You can use the Profiler GUI to script the trace and/or to display the trace data afterward. See http://weblogs.sqlteam.com/dang/archive/2007/12/16/Avoid-Causing-Problems-with-Profiler.aspx for more information. Show quoteHide quote "Fritz Theiss" <FritzThe***@discussions.microsoft.com> wrote in message news:7BAAA31F-54D1-462A-83FA-233D0FC1B1FD@microsoft.com... > thx so far. > > to answer the questions: > > 1) well, i do run sql profiler, nothing with sp_trace_create. > 2) yes, i am sure - as soon as profiler is stopped, space on c:\ gets > freed. > > -- > thanks in advance / danke im voraus, fritz > -- > Fritz Theiss > > > > "Carlos Sacristan" wrote: > >> >> Are you sure that the problem is SQL Profiler? How do you create the >> trace >> files (with sp_trace_create or maybe Profiler is running?) >> >> >> -- >> -- >> Un saludo >> ------------------------------- >> www.navento.com >> Servicios de Localización GPS >> >> >> "Fritz Theiss" wrote: >> >> > hi, >> > >> > i am running sql server 2005 profiler on a system, where not much space >> > is >> > left on c:\. that way i have configured profiler to write all files on >> > d:\, >> > which is more suitable here. however i clearly can see that c: is >> > somehow >> > affected as space is getting less and less here. as soon as the >> > profiler is >> > stopped and restarted - space is facing the same size as in the >> > beginning on >> > c:\. >> > >> > i am wondering, why it is like this in order to "disable" it. errorlog >> > is >> > facing the same size; the same for eventlogs... >> > >> > -- >> > thanks in advance / danke im voraus, fritz >> > -- >> > Fritz Theiss >> > Have you modified the %TEMP% and %TMP% environment variable to point to D:?
If not, might be worth a try. Right Click in My Computer -> Properties -> Advanced -> Environment Variables Show quoteHide quote "Fritz Theiss" <FritzThe***@discussions.microsoft.com> wrote in message news:DC2C67A0-9CFF-4404-8D24-49F019C8D40D@microsoft.com... > hi, > > i am running sql server 2005 profiler on a system, where not much space is > left on c:\. that way i have configured profiler to write all files on > d:\, > which is more suitable here. however i clearly can see that c: is somehow > affected as space is getting less and less here. as soon as the profiler > is > stopped and restarted - space is facing the same size as in the beginning > on > c:\. > > i am wondering, why it is like this in order to "disable" it. errorlog is > facing the same size; the same for eventlogs... > > -- > thanks in advance / danke im voraus, fritz > -- > Fritz Theiss > no, i did not as it was not necessary: two files are in %tmp% and %temp%
(both sharing the same physical location), but they are of size 0 bytes. this does not seem to be the problem... -- Show quoteHide quotethanks in advance / danke im voraus, fritz -- Fritz Theiss "LeoPasta" wrote: > Have you modified the %TEMP% and %TMP% environment variable to point to D:? > If not, might be worth a try. > Right Click in My Computer -> Properties -> Advanced -> Environment > Variables > > -- > Regards, > LeoPasta - http://sqlblogcasts.com/blogs/leopasta/default.aspx > > "Fritz Theiss" <FritzThe***@discussions.microsoft.com> wrote in message > news:DC2C67A0-9CFF-4404-8D24-49F019C8D40D@microsoft.com... > > hi, > > > > i am running sql server 2005 profiler on a system, where not much space is > > left on c:\. that way i have configured profiler to write all files on > > d:\, > > which is more suitable here. however i clearly can see that c: is somehow > > affected as space is getting less and less here. as soon as the profiler > > is > > stopped and restarted - space is facing the same size as in the beginning > > on > > c:\. > > > > i am wondering, why it is like this in order to "disable" it. errorlog is > > facing the same size; the same for eventlogs... > > > > -- > > thanks in advance / danke im voraus, fritz > > -- > > Fritz Theiss > > > > > Fritz Theiss (FritzThe***@discussions.microsoft.com) writes:
> no, i did not as it was not necessary: two files are in %tmp% and %temp% That may be because they are open for writing, so the real size does not> (both sharing the same physical location), but they are of size 0 bytes. > > this does not seem to be the problem... display. If you are short on space on C, you should change TEMP and TMP anyway. -- Erland Sommarskog, SQL Server MVP, esq***@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 i figured the problem out:
the environment variables of the user pointed to c:\. here i could find ..tmp-files with a size of more than 4 gb. as soon as profiler was ended these files passed by. i now configured these user environment variables to another partition... -- Show quoteHide quotethanks in advance / danke im voraus, fritz -- Fritz Theiss "Erland Sommarskog" wrote: > Fritz Theiss (FritzThe***@discussions.microsoft.com) writes: > > no, i did not as it was not necessary: two files are in %tmp% and %temp% > > (both sharing the same physical location), but they are of size 0 bytes. > > > > this does not seem to be the problem... > > That may be because they are open for writing, so the real size does not > display. > > If you are short on space on C, you should change TEMP and TMP anyway. > > > -- > Erland Sommarskog, SQL Server MVP, esq***@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 > > Profiler uses some temp directory. AFAIK, this is the same as where
you point Windows TMP or TEMP to. I strongly encourage you to do server side tracing instead of profiler. -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Fritz Theiss" <FritzThe***@discussions.microsoft.com> wrote in message news:DC2C67A0-9CFF-4404-8D24-49F019C8D40D@microsoft.com... > hi, > > i am running sql server 2005 profiler on a system, where not much > space is > left on c:\. that way i have configured profiler to write all files > on d:\, > which is more suitable here. however i clearly can see that c: is > somehow > affected as space is getting less and less here. as soon as the > profiler is > stopped and restarted - space is facing the same size as in the > beginning on > c:\. > > i am wondering, why it is like this in order to "disable" it. > errorlog is > facing the same size; the same for eventlogs... > > -- > thanks in advance / danke im voraus, fritz > -- > Fritz Theiss > Also, running tools such as Profiler and DTA on a remote machine if possible
is a best practice. -- Show quoteHide quoteEkrem Önsoy "Fritz Theiss" <FritzThe***@discussions.microsoft.com> wrote in message news:DC2C67A0-9CFF-4404-8D24-49F019C8D40D@microsoft.com... > hi, > > i am running sql server 2005 profiler on a system, where not much space is > left on c:\. that way i have configured profiler to write all files on > d:\, > which is more suitable here. however i clearly can see that c: is somehow > affected as space is getting less and less here. as soon as the profiler > is > stopped and restarted - space is facing the same size as in the beginning > on > c:\. > > i am wondering, why it is like this in order to "disable" it. errorlog is > facing the same size; the same for eventlogs... > > -- > thanks in advance / danke im voraus, fritz > -- > Fritz Theiss >  
Other interesting topics
SQL Maintenance Plans and Atomic Backups of a Set of Databases
Need help debugging this... SQL Management Studio and Small Business Server SQL Server 2005 Database Tuning Advisor Backup stratagy Overview DTE recommends an index that already exists but with a different . Help with SQL Profiler automatic bak filename generation Calling sqlcmd in a loop? Management Studio: Omit "Set" when modifying a proc |
|||||||||||||||||||||||
