Is there a guide to troubleshooting SQL 2005 performance or "Best Practice
for?".

We are running into issues in a clustered environment, and I want to perfmon
it, but want to make sure I'm catching the right thing. It's slow with 2
instances running in an active/active config, but if I put them both on the
same machine, it's faster... Strange, what should I be monitoring?

What is your Hardware configuration.
Does it have Enough memory/Processor Power.
divisions of memory for 2 instanes and one instance is a huge
difference.

Troubleshooting Performance Problems in SQL Server 2005
http://www.microsoft.com/technet/pro.../tsprfprb.mspx

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://DVD.kalendelaney.com


"Kevin A" <kevina@cqlcorp.com> wrote in message
news:946023DB-2501-4B51-899C-F595B604B4E0@microsoft.com...
> Is there a guide to troubleshooting SQL 2005 performance or "Best Practice
> for?".
>
> We are running into issues in a clustered environment, and I want to
> perfmon it, but want to make sure I'm catching the right thing. It's slow
> with 2 instances running in an active/active config, but if I put them
> both on the same machine, it's faster... Strange, what should I be
> monitoring?
>

> It's slow with 2 instances running in an active/active config, but if I put
them
> both on the same machine, it's faster... Strange, what should I be monitoring?

When you say 'faster' or 'slow', are you measuring something that does
distributed queries across the two instances?

Linchi

"Kevin A" wrote:

> Is there a guide to troubleshooting SQL 2005 performance or "Best Practice
> for?".
>
> We are running into issues in a clustered environment, and I want to perfmon
> it, but want to make sure I'm catching the right thing. It's slow with 2
> instances running in an active/active config, but if I put them both on the
> same machine, it's faster... Strange, what should I be monitoring?
>
>

Hi Kevin,

Take a look at the following online tutorials.

http://searchsqlserver.techtarget.co...302603,00.html

You need to begin measuring some performance metrics on your server in order
to identify exactly what is placing demands on which resources.

Best Regards,
John

"Kevin A" wrote:

> Is there a guide to troubleshooting SQL 2005 performance or "Best Practice
> for?".
>
> We are running into issues in a clustered environment, and I want to perfmon
> it, but want to make sure I'm catching the right thing. It's slow with 2
> instances running in an active/active config, but if I put them both on the
> same machine, it's faster... Strange, what should I be monitoring?
>
>

Hi Kevin,

Here is also a good article written by Microsoft for Troubleshooting SQL
Server 2005.

http://www.microsoft.com/technet/pro.../tsprfprb.mspx

Best Regards,
John

"John Sansom" wrote:

> Hi Kevin,
>
> Take a look at the following online tutorials.
>
> http://searchsqlserver.techtarget.co...302603,00.html
>
> You need to begin measuring some performance metrics on your server in order
> to identify exactly what is placing demands on which resources.
>
> Best Regards,
> John
>
> "Kevin A" wrote:
>
> > Is there a guide to troubleshooting SQL 2005 performance or "Best Practice
> > for?".
> >
> > We are running into issues in a clustered environment, and I want to perfmon
> > it, but want to make sure I'm catching the right thing. It's slow with 2
> > instances running in an active/active config, but if I put them both on the
> > same machine, it's faster... Strange, what should I be monitoring?
> >
> >

I thought this was a good article too, when I mentioned it in this same
thread...
;-)

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://DVD.kalendelaney.com


"John Sansom" <JohnSansom@discussions.microsoft.com> wrote in message
news:9790E953-E4D8-4D50-9F92-91F31DDEEA40@microsoft.com...
> Hi Kevin,
>
> Here is also a good article written by Microsoft for Troubleshooting SQL
> Server 2005.
>
> http://www.microsoft.com/technet/pro.../tsprfprb.mspx
>
> Best Regards,
> John
>
> "John Sansom" wrote:
>
>> Hi Kevin,
>>
>> Take a look at the following online tutorials.
>>
>> http://searchsqlserver.techtarget.co...302603,00.html
>>
>> You need to begin measuring some performance metrics on your server in
>> order
>> to identify exactly what is placing demands on which resources.
>>
>> Best Regards,
>> John
>>
>> "Kevin A" wrote:
>>
>> > Is there a guide to troubleshooting SQL 2005 performance or "Best
>> > Practice
>> > for?".
>> >
>> > We are running into issues in a clustered environment, and I want to
>> > perfmon
>> > it, but want to make sure I'm catching the right thing. It's slow with
>> > 2
>> > instances running in an active/active config, but if I put them both on
>> > the
>> > same machine, it's faster... Strange, what should I be monitoring?
>> >
>> >

A fair point :-)

"Kalen Delaney" wrote:

> I thought this was a good article too, when I mentioned it in this same
> thread...
> ;-)
>
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://DVD.kalendelaney.com
>
>
> "John Sansom" <JohnSansom@discussions.microsoft.com> wrote in message
> news:9790E953-E4D8-4D50-9F92-91F31DDEEA40@microsoft.com...
> > Hi Kevin,
> >
> > Here is also a good article written by Microsoft for Troubleshooting SQL
> > Server 2005.
> >
> > http://www.microsoft.com/technet/pro.../tsprfprb.mspx
> >
> > Best Regards,
> > John
> >
> > "John Sansom" wrote:
> >
> >> Hi Kevin,
> >>
> >> Take a look at the following online tutorials.
> >>
> >> http://searchsqlserver.techtarget.co...302603,00.html
> >>
> >> You need to begin measuring some performance metrics on your server in
> >> order
> >> to identify exactly what is placing demands on which resources.
> >>
> >> Best Regards,
> >> John
> >>
> >> "Kevin A" wrote:
> >>
> >> > Is there a guide to troubleshooting SQL 2005 performance or "Best
> >> > Practice
> >> > for?".
> >> >
> >> > We are running into issues in a clustered environment, and I want to
> >> > perfmon
> >> > it, but want to make sure I'm catching the right thing. It's slow with
> >> > 2
> >> > instances running in an active/active config, but if I put them both on
> >> > the
> >> > same machine, it's faster... Strange, what should I be monitoring?
> >> >
> >> >
>
>
>

Can I jump in too and state that it is a very good article!??! :-)

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Kalen Delaney" <replies@public_newsgroups.com> wrote in message
news:eq$VU9W1IHA.1240@TK2MSFTNGP02.phx.gbl...
>I thought this was a good article too, when I mentioned it in this same
>thread...
> ;-)
>
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://DVD.kalendelaney.com
>
>
> "John Sansom" <JohnSansom@discussions.microsoft.com> wrote in message
> news:9790E953-E4D8-4D50-9F92-91F31DDEEA40@microsoft.com...
>> Hi Kevin,
>>
>> Here is also a good article written by Microsoft for Troubleshooting SQL
>> Server 2005.
>>
>> http://www.microsoft.com/technet/pro.../tsprfprb.mspx
>>
>> Best Regards,
>> John
>>
>> "John Sansom" wrote:
>>
>>> Hi Kevin,
>>>
>>> Take a look at the following online tutorials.
>>>
>>> http://searchsqlserver.techtarget.co...302603,00.html
>>>
>>> You need to begin measuring some performance metrics on your server in
>>> order
>>> to identify exactly what is placing demands on which resources.
>>>
>>> Best Regards,
>>> John
>>>
>>> "Kevin A" wrote:
>>>
>>> > Is there a guide to troubleshooting SQL 2005 performance or "Best
>>> > Practice
>>> > for?".
>>> >
>>> > We are running into issues in a clustered environment, and I want to
>>> > perfmon
>>> > it, but want to make sure I'm catching the right thing. It's slow
>>> > with 2
>>> > instances running in an active/active config, but if I put them both
>>> > on the
>>> > same machine, it's faster... Strange, what should I be monitoring?
>>> >
>>> >
>
>