I am using a remote connection to connect to a specific server (13B) and I a
m
running a trace from there against another server (138). I have a template t
o
track performance points and am saving the results to a table. My problem is
that when I run this trace, I also am creating a very large set of tmp files
on the local C drive of 13B. The files are named nst1.tmp,prf3.tmp,prf4.tmp.
The C drive space is not very large so I max out the space quickly. I am
looking for a way to point the tmp files to another drive or elimate them
altogether.
ThanksNever go directly to a table. Place the files on a local hard drive first
and then import them later. Otherwise you will incur more overhead than you
need to. If you want to import Perfmon files take a look at the Logman.exe
utility.
Andrew J. Kelly SQL MVP
"MNDiver" <MNDiver@.discussions.microsoft.com> wrote in message
news:1F3F9BF1-5D66-4882-83A2-19C28F1522B1@.microsoft.com...
>I am using a remote connection to connect to a specific server (13B) and I
>am
> running a trace from there against another server (138). I have a template
> to
> track performance points and am saving the results to a table. My problem
> is
> that when I run this trace, I also am creating a very large set of tmp
> files
> on the local C drive of 13B. The files are named
> nst1.tmp,prf3.tmp,prf4.tmp.
> The C drive space is not very large so I max out the space quickly. I am
> looking for a way to point the tmp files to another drive or elimate them
> altogether.
> Thanks
Showing posts with label mon. Show all posts
Showing posts with label mon. Show all posts
Monday, February 20, 2012
Perf Mon
I want to monitor avg disk queue length and cpu for the
last ten minutes to see if one or the other has exceeded
a certain threshold during that time. If so, I want to
get an email.
1. Can this occur with Perf Mon?
2. Are there any third party tools that can do this?NoMoFlo,
#1. Iam unaware of an alert facility in perfmon.
#2. MS has another tool called Microsoft Operations Manager (MOM)
http://www.microsoft.com/mom/ .
A good third party tool is SiteScope:
'Mercury SiteScope'
scope/" target="_blank">http://www.mercury.com/us/products/...e
scope/
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx
.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Hi,
There is anothor best tool from BMC . Name of thre tool is BMC PATROL.
Using this we can monitor the online performance , Email Alert, as well as
see the history .
http://www.bmc.com/products/
Thanks
Hari
MCDBA
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx
.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Go to Administrative Tools then to Performance. In the
PerfMon console tree, go to the Performance Logs and Alerts
node and then select Alerts. Right click and select New
Alert Settings to create a PerfMon alert. After providing a
name for the alert, you can set up the counters and
thresholds. On the Action tab, you can set up the response
to the counters exceeding the threshold.
You can right click on alerts, select help and get more
information on setting this up.
-Sue
On Thu, 24 Jun 2004 14:23:22 -0700, "NoMoFlo"
<anonymous@.discussions.microsoft.com> wrote:
>I want to monitor avg disk queue length and cpu for the
>last ten minutes to see if one or the other has exceeded
>a certain threshold during that time. If so, I want to
>get an email.
>1. Can this occur with Perf Mon?
>2. Are there any third party tools that can do this?
last ten minutes to see if one or the other has exceeded
a certain threshold during that time. If so, I want to
get an email.
1. Can this occur with Perf Mon?
2. Are there any third party tools that can do this?NoMoFlo,
#1. Iam unaware of an alert facility in perfmon.
#2. MS has another tool called Microsoft Operations Manager (MOM)
http://www.microsoft.com/mom/ .
A good third party tool is SiteScope:
'Mercury SiteScope'
scope/" target="_blank">http://www.mercury.com/us/products/...e
scope/
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx
.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Hi,
There is anothor best tool from BMC . Name of thre tool is BMC PATROL.
Using this we can monitor the online performance , Email Alert, as well as
see the history .
http://www.bmc.com/products/
Thanks
Hari
MCDBA
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx
.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Go to Administrative Tools then to Performance. In the
PerfMon console tree, go to the Performance Logs and Alerts
node and then select Alerts. Right click and select New
Alert Settings to create a PerfMon alert. After providing a
name for the alert, you can set up the counters and
thresholds. On the Action tab, you can set up the response
to the counters exceeding the threshold.
You can right click on alerts, select help and get more
information on setting this up.
-Sue
On Thu, 24 Jun 2004 14:23:22 -0700, "NoMoFlo"
<anonymous@.discussions.microsoft.com> wrote:
>I want to monitor avg disk queue length and cpu for the
>last ten minutes to see if one or the other has exceeded
>a certain threshold during that time. If so, I want to
>get an email.
>1. Can this occur with Perf Mon?
>2. Are there any third party tools that can do this?
Perf Mon
I want to monitor avg disk queue length and cpu for the
last ten minutes to see if one or the other has exceeded
a certain threshold during that time. If so, I want to
get an email.
1. Can this occur with Perf Mon?
2. Are there any third party tools that can do this?NoMoFlo,
#1. Iam unaware of an alert facility in perfmon.
#2. MS has another tool called Microsoft Operations Manager (MOM)
http://www.microsoft.com/mom/ .
A good third party tool is SiteScope:
'Mercury SiteScope'
http://www.mercury.com/us/products/application-management/foundation/monitors/sitescope/
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Hi,
There is anothor best tool from BMC . Name of thre tool is BMC PATROL.
Using this we can monitor the online performance , Email Alert, as well as
see the history .
http://www.bmc.com/products/
--
Thanks
Hari
MCDBA
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Go to Administrative Tools then to Performance. In the
PerfMon console tree, go to the Performance Logs and Alerts
node and then select Alerts. Right click and select New
Alert Settings to create a PerfMon alert. After providing a
name for the alert, you can set up the counters and
thresholds. On the Action tab, you can set up the response
to the counters exceeding the threshold.
You can right click on alerts, select help and get more
information on setting this up.
-Sue
On Thu, 24 Jun 2004 14:23:22 -0700, "NoMoFlo"
<anonymous@.discussions.microsoft.com> wrote:
>I want to monitor avg disk queue length and cpu for the
>last ten minutes to see if one or the other has exceeded
>a certain threshold during that time. If so, I want to
>get an email.
>1. Can this occur with Perf Mon?
>2. Are there any third party tools that can do this?
last ten minutes to see if one or the other has exceeded
a certain threshold during that time. If so, I want to
get an email.
1. Can this occur with Perf Mon?
2. Are there any third party tools that can do this?NoMoFlo,
#1. Iam unaware of an alert facility in perfmon.
#2. MS has another tool called Microsoft Operations Manager (MOM)
http://www.microsoft.com/mom/ .
A good third party tool is SiteScope:
'Mercury SiteScope'
http://www.mercury.com/us/products/application-management/foundation/monitors/sitescope/
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Hi,
There is anothor best tool from BMC . Name of thre tool is BMC PATROL.
Using this we can monitor the online performance , Email Alert, as well as
see the history .
http://www.bmc.com/products/
--
Thanks
Hari
MCDBA
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Go to Administrative Tools then to Performance. In the
PerfMon console tree, go to the Performance Logs and Alerts
node and then select Alerts. Right click and select New
Alert Settings to create a PerfMon alert. After providing a
name for the alert, you can set up the counters and
thresholds. On the Action tab, you can set up the response
to the counters exceeding the threshold.
You can right click on alerts, select help and get more
information on setting this up.
-Sue
On Thu, 24 Jun 2004 14:23:22 -0700, "NoMoFlo"
<anonymous@.discussions.microsoft.com> wrote:
>I want to monitor avg disk queue length and cpu for the
>last ten minutes to see if one or the other has exceeded
>a certain threshold during that time. If so, I want to
>get an email.
>1. Can this occur with Perf Mon?
>2. Are there any third party tools that can do this?
Perf Mon
Hi,
SQL Server 2005 sp1
The object General Statistics: User Connections has a value of 1400
The object General Statistics:Logical Connections has avalue of 1000
Does anyone know why there is a differenece in the values?
Thanks,
YanHi
Is this applicable?
http://support.microsoft.com/kb/922118
John
"Yan" <yaniv.etrogi@.gmail.com> wrote in message
news:eLbfLtibIHA.4196@.TK2MSFTNGP04.phx.gbl...
> Hi,
> SQL Server 2005 sp1
>
> The object General Statistics: User Connections has a value of 1400
> The object General Statistics:Logical Connections has avalue of 1000
>
> Does anyone know why there is a differenece in the values?
>
> Thanks,
> Yan
>|||You may also want to check if this is occuring!
http://support.microsoft.com/kb/937745
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eNN0sgybIHA.4652@.TK2MSFTNGP06.phx.gbl...
> Hi
> Is this applicable?
> http://support.microsoft.com/kb/922118
> John
>
> "Yan" <yaniv.etrogi@.gmail.com> wrote in message
> news:eLbfLtibIHA.4196@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> SQL Server 2005 sp1
>>
>> The object General Statistics: User Connections has a value of 1400
>> The object General Statistics:Logical Connections has avalue of 1000
>>
>> Does anyone know why there is a differenece in the values?
>>
>> Thanks,
>> Yan
>
SQL Server 2005 sp1
The object General Statistics: User Connections has a value of 1400
The object General Statistics:Logical Connections has avalue of 1000
Does anyone know why there is a differenece in the values?
Thanks,
YanHi
Is this applicable?
http://support.microsoft.com/kb/922118
John
"Yan" <yaniv.etrogi@.gmail.com> wrote in message
news:eLbfLtibIHA.4196@.TK2MSFTNGP04.phx.gbl...
> Hi,
> SQL Server 2005 sp1
>
> The object General Statistics: User Connections has a value of 1400
> The object General Statistics:Logical Connections has avalue of 1000
>
> Does anyone know why there is a differenece in the values?
>
> Thanks,
> Yan
>|||You may also want to check if this is occuring!
http://support.microsoft.com/kb/937745
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eNN0sgybIHA.4652@.TK2MSFTNGP06.phx.gbl...
> Hi
> Is this applicable?
> http://support.microsoft.com/kb/922118
> John
>
> "Yan" <yaniv.etrogi@.gmail.com> wrote in message
> news:eLbfLtibIHA.4196@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> SQL Server 2005 sp1
>>
>> The object General Statistics: User Connections has a value of 1400
>> The object General Statistics:Logical Connections has avalue of 1000
>>
>> Does anyone know why there is a differenece in the values?
>>
>> Thanks,
>> Yan
>
Perf Mon
Hi,
SQL Server 2005 sp1
The object General Statistics: User Connections has a value of 1400
The object General Statistics:Logical Connections has avalue of 1000
Does anyone know why there is a differenece in the values?
Thanks,
Yan
Hi
Is this applicable?
http://support.microsoft.com/kb/922118
John
"Yan" <yaniv.etrogi@.gmail.com> wrote in message
news:eLbfLtibIHA.4196@.TK2MSFTNGP04.phx.gbl...
> Hi,
> SQL Server 2005 sp1
>
> The object General Statistics: User Connections has a value of 1400
> The object General Statistics:Logical Connections has avalue of 1000
>
> Does anyone know why there is a differenece in the values?
>
> Thanks,
> Yan
>
|||You may also want to check if this is occuring!
http://support.microsoft.com/kb/937745
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eNN0sgybIHA.4652@.TK2MSFTNGP06.phx.gbl...
> Hi
> Is this applicable?
> http://support.microsoft.com/kb/922118
> John
>
> "Yan" <yaniv.etrogi@.gmail.com> wrote in message
> news:eLbfLtibIHA.4196@.TK2MSFTNGP04.phx.gbl...
>
SQL Server 2005 sp1
The object General Statistics: User Connections has a value of 1400
The object General Statistics:Logical Connections has avalue of 1000
Does anyone know why there is a differenece in the values?
Thanks,
Yan
Hi
Is this applicable?
http://support.microsoft.com/kb/922118
John
"Yan" <yaniv.etrogi@.gmail.com> wrote in message
news:eLbfLtibIHA.4196@.TK2MSFTNGP04.phx.gbl...
> Hi,
> SQL Server 2005 sp1
>
> The object General Statistics: User Connections has a value of 1400
> The object General Statistics:Logical Connections has avalue of 1000
>
> Does anyone know why there is a differenece in the values?
>
> Thanks,
> Yan
>
|||You may also want to check if this is occuring!
http://support.microsoft.com/kb/937745
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eNN0sgybIHA.4652@.TK2MSFTNGP06.phx.gbl...
> Hi
> Is this applicable?
> http://support.microsoft.com/kb/922118
> John
>
> "Yan" <yaniv.etrogi@.gmail.com> wrote in message
> news:eLbfLtibIHA.4196@.TK2MSFTNGP04.phx.gbl...
>
Perf Mon
I want to monitor avg disk queue length and cpu for the
last ten minutes to see if one or the other has exceeded
a certain threshold during that time. If so, I want to
get an email.
1. Can this occur with Perf Mon?
2. Are there any third party tools that can do this?
NoMoFlo,
#1. Iam unaware of an alert facility in perfmon.
#2. MS has another tool called Microsoft Operations Manager (MOM)
http://www.microsoft.com/mom/ .
A good third party tool is SiteScope:
'Mercury SiteScope'
http://www.mercury.com/us/products/a...ors/sitescope/
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?
|||Hi,
There is anothor best tool from BMC . Name of thre tool is BMC PATROL.
Using this we can monitor the online performance , Email Alert, as well as
see the history .
http://www.bmc.com/products/
Thanks
Hari
MCDBA
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?
|||Go to Administrative Tools then to Performance. In the
PerfMon console tree, go to the Performance Logs and Alerts
node and then select Alerts. Right click and select New
Alert Settings to create a PerfMon alert. After providing a
name for the alert, you can set up the counters and
thresholds. On the Action tab, you can set up the response
to the counters exceeding the threshold.
You can right click on alerts, select help and get more
information on setting this up.
-Sue
On Thu, 24 Jun 2004 14:23:22 -0700, "NoMoFlo"
<anonymous@.discussions.microsoft.com> wrote:
>I want to monitor avg disk queue length and cpu for the
>last ten minutes to see if one or the other has exceeded
>a certain threshold during that time. If so, I want to
>get an email.
>1. Can this occur with Perf Mon?
>2. Are there any third party tools that can do this?
last ten minutes to see if one or the other has exceeded
a certain threshold during that time. If so, I want to
get an email.
1. Can this occur with Perf Mon?
2. Are there any third party tools that can do this?
NoMoFlo,
#1. Iam unaware of an alert facility in perfmon.
#2. MS has another tool called Microsoft Operations Manager (MOM)
http://www.microsoft.com/mom/ .
A good third party tool is SiteScope:
'Mercury SiteScope'
http://www.mercury.com/us/products/a...ors/sitescope/
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?
|||Hi,
There is anothor best tool from BMC . Name of thre tool is BMC PATROL.
Using this we can monitor the online performance , Email Alert, as well as
see the history .
http://www.bmc.com/products/
Thanks
Hari
MCDBA
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?
|||Go to Administrative Tools then to Performance. In the
PerfMon console tree, go to the Performance Logs and Alerts
node and then select Alerts. Right click and select New
Alert Settings to create a PerfMon alert. After providing a
name for the alert, you can set up the counters and
thresholds. On the Action tab, you can set up the response
to the counters exceeding the threshold.
You can right click on alerts, select help and get more
information on setting this up.
-Sue
On Thu, 24 Jun 2004 14:23:22 -0700, "NoMoFlo"
<anonymous@.discussions.microsoft.com> wrote:
>I want to monitor avg disk queue length and cpu for the
>last ten minutes to see if one or the other has exceeded
>a certain threshold during that time. If so, I want to
>get an email.
>1. Can this occur with Perf Mon?
>2. Are there any third party tools that can do this?
Subscribe to:
Posts (Atom)