dbTalk Databases Forums  

SQL Perf Counters Log keeps stopping

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SQL Perf Counters Log keeps stopping in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Carlos
 
Posts: n/a

Default SQL Perf Counters Log keeps stopping - 06-19-2008 , 10:59 AM






Initially I had created a Perf Counter Log job that would save it to a text
(csv) file. Recently I decided to start saving the information to SQL tables
and since then SQL Perf Counters Log keeps stopping at random hours; I set up
the Stop log After Option to 300 day Units and the When a log file closes to
Start a new log file.

I have had to start the Log file manually everytime; is there anything I can
do about it or should I go back to saving it to csv files?

Thanks,

Reply With Quote
  #2  
Old   
Sean McCown
 
Posts: n/a

Default RE: SQL Perf Counters Log keeps stopping - 06-30-2008 , 01:48 PM






I can't say that I've ever had this problem. Can you correlate the stops to
anything in the NT or SQL error logs?


--

<Font style="color:darkred; font-size: 12pt">
Watch my free SQL Server Tutorials at:
<a href="http://MidnightDBA.ITBookworm.com"
target="_new">http://MidnightDBA.ITBookworm.com </a>

Read my book reviews at:
<a href="http://www.ITBookworm.com" target="_new">www.ITBookworm.com</a>

Blog Author of:
DBA Rant – <a href="http://dbarant.blogspot.com"
target="_new">http://dbarant.blogspot.com </a>
</font>



"Carlos" wrote:

Quote:
Initially I had created a Perf Counter Log job that would save it to a text
(csv) file. Recently I decided to start saving the information to SQL tables
and since then SQL Perf Counters Log keeps stopping at random hours; I set up
the Stop log After Option to 300 day Units and the When a log file closes to
Start a new log file.

I have had to start the Log file manually everytime; is there anything I can
do about it or should I go back to saving it to csv files?

Thanks,

Reply With Quote
  #3  
Old   
Sean McCown
 
Posts: n/a

Default RE: SQL Perf Counters Log keeps stopping - 06-30-2008 , 01:48 PM



I can't say that I've ever had this problem. Can you correlate the stops to
anything in the NT or SQL error logs?


--

<Font style="color:darkred; font-size: 12pt">
Watch my free SQL Server Tutorials at:
<a href="http://MidnightDBA.ITBookworm.com"
target="_new">http://MidnightDBA.ITBookworm.com </a>

Read my book reviews at:
<a href="http://www.ITBookworm.com" target="_new">www.ITBookworm.com</a>

Blog Author of:
DBA Rant – <a href="http://dbarant.blogspot.com"
target="_new">http://dbarant.blogspot.com </a>
</font>



"Carlos" wrote:

Quote:
Initially I had created a Perf Counter Log job that would save it to a text
(csv) file. Recently I decided to start saving the information to SQL tables
and since then SQL Perf Counters Log keeps stopping at random hours; I set up
the Stop log After Option to 300 day Units and the When a log file closes to
Start a new log file.

I have had to start the Log file manually everytime; is there anything I can
do about it or should I go back to saving it to csv files?

Thanks,

Reply With Quote
  #4  
Old   
Sean McCown
 
Posts: n/a

Default RE: SQL Perf Counters Log keeps stopping - 06-30-2008 , 01:48 PM



I can't say that I've ever had this problem. Can you correlate the stops to
anything in the NT or SQL error logs?


--

<Font style="color:darkred; font-size: 12pt">
Watch my free SQL Server Tutorials at:
<a href="http://MidnightDBA.ITBookworm.com"
target="_new">http://MidnightDBA.ITBookworm.com </a>

Read my book reviews at:
<a href="http://www.ITBookworm.com" target="_new">www.ITBookworm.com</a>

Blog Author of:
DBA Rant – <a href="http://dbarant.blogspot.com"
target="_new">http://dbarant.blogspot.com </a>
</font>



"Carlos" wrote:

Quote:
Initially I had created a Perf Counter Log job that would save it to a text
(csv) file. Recently I decided to start saving the information to SQL tables
and since then SQL Perf Counters Log keeps stopping at random hours; I set up
the Stop log After Option to 300 day Units and the When a log file closes to
Start a new log file.

I have had to start the Log file manually everytime; is there anything I can
do about it or should I go back to saving it to csv files?

Thanks,

Reply With Quote
  #5  
Old   
Sean McCown
 
Posts: n/a

Default RE: SQL Perf Counters Log keeps stopping - 06-30-2008 , 01:48 PM



I can't say that I've ever had this problem. Can you correlate the stops to
anything in the NT or SQL error logs?


--

<Font style="color:darkred; font-size: 12pt">
Watch my free SQL Server Tutorials at:
<a href="http://MidnightDBA.ITBookworm.com"
target="_new">http://MidnightDBA.ITBookworm.com </a>

Read my book reviews at:
<a href="http://www.ITBookworm.com" target="_new">www.ITBookworm.com</a>

Blog Author of:
DBA Rant – <a href="http://dbarant.blogspot.com"
target="_new">http://dbarant.blogspot.com </a>
</font>



"Carlos" wrote:

Quote:
Initially I had created a Perf Counter Log job that would save it to a text
(csv) file. Recently I decided to start saving the information to SQL tables
and since then SQL Perf Counters Log keeps stopping at random hours; I set up
the Stop log After Option to 300 day Units and the When a log file closes to
Start a new log file.

I have had to start the Log file manually everytime; is there anything I can
do about it or should I go back to saving it to csv files?

Thanks,

Reply With Quote
  #6  
Old   
Sean McCown
 
Posts: n/a

Default RE: SQL Perf Counters Log keeps stopping - 06-30-2008 , 01:48 PM



I can't say that I've ever had this problem. Can you correlate the stops to
anything in the NT or SQL error logs?


--

<Font style="color:darkred; font-size: 12pt">
Watch my free SQL Server Tutorials at:
<a href="http://MidnightDBA.ITBookworm.com"
target="_new">http://MidnightDBA.ITBookworm.com </a>

Read my book reviews at:
<a href="http://www.ITBookworm.com" target="_new">www.ITBookworm.com</a>

Blog Author of:
DBA Rant – <a href="http://dbarant.blogspot.com"
target="_new">http://dbarant.blogspot.com </a>
</font>



"Carlos" wrote:

Quote:
Initially I had created a Perf Counter Log job that would save it to a text
(csv) file. Recently I decided to start saving the information to SQL tables
and since then SQL Perf Counters Log keeps stopping at random hours; I set up
the Stop log After Option to 300 day Units and the When a log file closes to
Start a new log file.

I have had to start the Log file manually everytime; is there anything I can
do about it or should I go back to saving it to csv files?

Thanks,

Reply With Quote
  #7  
Old   
Sean McCown
 
Posts: n/a

Default RE: SQL Perf Counters Log keeps stopping - 06-30-2008 , 01:48 PM



I can't say that I've ever had this problem. Can you correlate the stops to
anything in the NT or SQL error logs?


--

<Font style="color:darkred; font-size: 12pt">
Watch my free SQL Server Tutorials at:
<a href="http://MidnightDBA.ITBookworm.com"
target="_new">http://MidnightDBA.ITBookworm.com </a>

Read my book reviews at:
<a href="http://www.ITBookworm.com" target="_new">www.ITBookworm.com</a>

Blog Author of:
DBA Rant – <a href="http://dbarant.blogspot.com"
target="_new">http://dbarant.blogspot.com </a>
</font>



"Carlos" wrote:

Quote:
Initially I had created a Perf Counter Log job that would save it to a text
(csv) file. Recently I decided to start saving the information to SQL tables
and since then SQL Perf Counters Log keeps stopping at random hours; I set up
the Stop log After Option to 300 day Units and the When a log file closes to
Start a new log file.

I have had to start the Log file manually everytime; is there anything I can
do about it or should I go back to saving it to csv files?

Thanks,

Reply With Quote
  #8  
Old   
Sean McCown
 
Posts: n/a

Default RE: SQL Perf Counters Log keeps stopping - 06-30-2008 , 01:48 PM



I can't say that I've ever had this problem. Can you correlate the stops to
anything in the NT or SQL error logs?


--

<Font style="color:darkred; font-size: 12pt">
Watch my free SQL Server Tutorials at:
<a href="http://MidnightDBA.ITBookworm.com"
target="_new">http://MidnightDBA.ITBookworm.com </a>

Read my book reviews at:
<a href="http://www.ITBookworm.com" target="_new">www.ITBookworm.com</a>

Blog Author of:
DBA Rant – <a href="http://dbarant.blogspot.com"
target="_new">http://dbarant.blogspot.com </a>
</font>



"Carlos" wrote:

Quote:
Initially I had created a Perf Counter Log job that would save it to a text
(csv) file. Recently I decided to start saving the information to SQL tables
and since then SQL Perf Counters Log keeps stopping at random hours; I set up
the Stop log After Option to 300 day Units and the When a log file closes to
Start a new log file.

I have had to start the Log file manually everytime; is there anything I can
do about it or should I go back to saving it to csv files?

Thanks,

Reply With Quote
  #9  
Old   
Sean McCown
 
Posts: n/a

Default RE: SQL Perf Counters Log keeps stopping - 06-30-2008 , 01:48 PM



I can't say that I've ever had this problem. Can you correlate the stops to
anything in the NT or SQL error logs?


--

<Font style="color:darkred; font-size: 12pt">
Watch my free SQL Server Tutorials at:
<a href="http://MidnightDBA.ITBookworm.com"
target="_new">http://MidnightDBA.ITBookworm.com </a>

Read my book reviews at:
<a href="http://www.ITBookworm.com" target="_new">www.ITBookworm.com</a>

Blog Author of:
DBA Rant – <a href="http://dbarant.blogspot.com"
target="_new">http://dbarant.blogspot.com </a>
</font>



"Carlos" wrote:

Quote:
Initially I had created a Perf Counter Log job that would save it to a text
(csv) file. Recently I decided to start saving the information to SQL tables
and since then SQL Perf Counters Log keeps stopping at random hours; I set up
the Stop log After Option to 300 day Units and the When a log file closes to
Start a new log file.

I have had to start the Log file manually everytime; is there anything I can
do about it or should I go back to saving it to csv files?

Thanks,

Reply With Quote
  #10  
Old   
Sean McCown
 
Posts: n/a

Default RE: SQL Perf Counters Log keeps stopping - 06-30-2008 , 01:48 PM



I can't say that I've ever had this problem. Can you correlate the stops to
anything in the NT or SQL error logs?


--

<Font style="color:darkred; font-size: 12pt">
Watch my free SQL Server Tutorials at:
<a href="http://MidnightDBA.ITBookworm.com"
target="_new">http://MidnightDBA.ITBookworm.com </a>

Read my book reviews at:
<a href="http://www.ITBookworm.com" target="_new">www.ITBookworm.com</a>

Blog Author of:
DBA Rant – <a href="http://dbarant.blogspot.com"
target="_new">http://dbarant.blogspot.com </a>
</font>



"Carlos" wrote:

Quote:
Initially I had created a Perf Counter Log job that would save it to a text
(csv) file. Recently I decided to start saving the information to SQL tables
and since then SQL Perf Counters Log keeps stopping at random hours; I set up
the Stop log After Option to 300 day Units and the When a log file closes to
Start a new log file.

I have had to start the Log file manually everytime; is there anything I can
do about it or should I go back to saving it to csv files?

Thanks,

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.