Capture counters to analyze disk I/O contention

Hi,
I'm trying to capture some counters in perfmon/sysmon that would help me
analyze if there is any disk I/O contention between SQL and other processes
(OS and/or others). Does anyone know if there is/are any counters that will
allow me to capture this info?
Thanks.Hi
TYou don't give the version of SQL Server you are using! For SQL 2000 you
may want to look at DBCC SQLPERF (WAITSTATS) or the DMVs in SQL 2005 see
http://blogs.msdn.com/sqlcat/archiv.../05/461199.aspx for examples.
For performance counters you can not separate the individual process usage
but you can see the general usage and
http://www.sql-server-performance.c...nce_article.asp
lists some of the counters you can look at. You may have to use emperical
observations to decide what is causing the contention, e.g. Make
observations; separate logs from data files; make observations; move tempdb
to it's own spindles; make observations;
separate databases onto own spindles; make observations; etc...
If you are using a SAN then you can also get stats from that (but it will
not identify the specific processes).
John
"Rob" wrote:

> Hi,
> I'm trying to capture some counters in perfmon/sysmon that would help me
> analyze if there is any disk I/O contention between SQL and other processe
s
> (OS and/or others). Does anyone know if there is/are any counters that wil
l
> allow me to capture this info?
> Thanks.

Capture counters to analyze disk I/O contention

Hi,
I'm trying to capture some counters in perfmon/sysmon that would help me
analyze if there is any disk I/O contention between SQL and other processes
(OS and/or others). Does anyone know if there is/are any counters that will
allow me to capture this info?
Thanks.Hi
TYou don't give the version of SQL Server you are using! For SQL 2000 you
may want to look at DBCC SQLPERF (WAITSTATS) or the DMVs in SQL 2005 see
http://blogs.msdn.com/sqlcat/archive/2005/09/05/461199.aspx for examples.
For performance counters you can not separate the individual process usage
but you can see the general usage and
http://www.sql-server-performance.com/sg_sql_server_performance_article.asp
lists some of the counters you can look at. You may have to use emperical
observations to decide what is causing the contention, e.g. Make
observations; separate logs from data files; make observations; move tempdb
to it's own spindles; make observations;
separate databases onto own spindles; make observations; etc...
If you are using a SAN then you can also get stats from that (but it will
not identify the specific processes).
John
"Rob" wrote:
> Hi,
> I'm trying to capture some counters in perfmon/sysmon that would help me
> analyze if there is any disk I/O contention between SQL and other processes
> (OS and/or others). Does anyone know if there is/are any counters that will
> allow me to capture this info?
> Thanks.

Capture counters to analyze disk I/O contention

Hi,
I'm trying to capture some counters in perfmon/sysmon that would help me
analyze if there is any disk I/O contention between SQL and other processes
(OS and/or others). Does anyone know if there is/are any counters that will
allow me to capture this info?
Thanks.
Hi
TYou don't give the version of SQL Server you are using! For SQL 2000 you
may want to look at DBCC SQLPERF (WAITSTATS) or the DMVs in SQL 2005 see
http://blogs.msdn.com/sqlcat/archive...05/461199.aspx for examples.
For performance counters you can not separate the individual process usage
but you can see the general usage and
http://www.sql-server-performance.co...ce_article.asp
lists some of the counters you can look at. You may have to use emperical
observations to decide what is causing the contention, e.g. Make
observations; separate logs from data files; make observations; move tempdb
to it's own spindles; make observations;
separate databases onto own spindles; make observations; etc...
If you are using a SAN then you can also get stats from that (but it will
not identify the specific processes).
John
"Rob" wrote:

> Hi,
> I'm trying to capture some counters in perfmon/sysmon that would help me
> analyze if there is any disk I/O contention between SQL and other processes
> (OS and/or others). Does anyone know if there is/are any counters that will
> allow me to capture this info?
> Thanks.

cant view recently added disk

I just added a new disk on a 2003 server box running sql 2000 and i want to
redirect my backups to the new disk (which resides on our EMC), the disk
shows up and i was able to add it as a new resource in cluster manager but it
doesnt show up in sql enterprise manager. Any thoughts? Thanks
You must add the disk as a dependency to the SQL Server.
Add the Resource to the SQL server group. Take the SQL Server offline.
Right click the SQL Server resource (not the group) and choose Properties.
Select the Dependencies tab. Add the new disk resource to the Resource
dependencies list. OK. Bring the entire SQL group online.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"ampsman78" <ampsman78@.discussions.microsoft.com> wrote in message
news:29D391B2-28D0-4071-9C01-80DD1C3CA561@.microsoft.com...
> I just added a new disk on a 2003 server box running sql 2000 and i want
to
> redirect my backups to the new disk (which resides on our EMC), the disk
> shows up and i was able to add it as a new resource in cluster manager but
it
> doesnt show up in sql enterprise manager. Any thoughts? Thanks

cant view recently added disk

I just added a new disk on a 2003 server box running sql 2000 and i want to
redirect my backups to the new disk (which resides on our EMC), the disk
shows up and i was able to add it as a new resource in cluster manager but it
doesnt show up in sql enterprise manager. Any thoughts? ThanksYou must add the disk as a dependency to the SQL Server.
Add the Resource to the SQL server group. Take the SQL Server offline.
Right click the SQL Server resource (not the group) and choose Properties.
Select the Dependencies tab. Add the new disk resource to the Resource
dependencies list. OK. Bring the entire SQL group online.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"ampsman78" <ampsman78@.discussions.microsoft.com> wrote in message
news:29D391B2-28D0-4071-9C01-80DD1C3CA561@.microsoft.com...
> I just added a new disk on a 2003 server box running sql 2000 and i want
to
> redirect my backups to the new disk (which resides on our EMC), the disk
> shows up and i was able to add it as a new resource in cluster manager but
it
> doesnt show up in sql enterprise manager. Any thoughts? Thanks

cant view recently added disk

I just added a new disk on a 2003 server box running sql 2000 and i want to
redirect my backups to the new disk (which resides on our EMC), the disk
shows up and i was able to add it as a new resource in cluster manager but i
t
doesnt show up in sql enterprise manager. Any thoughts? ThanksYou must add the disk as a dependency to the SQL Server.
Add the Resource to the SQL server group. Take the SQL Server offline.
Right click the SQL Server resource (not the group) and choose Properties.
Select the Dependencies tab. Add the new disk resource to the Resource
dependencies list. OK. Bring the entire SQL group online.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"ampsman78" <ampsman78@.discussions.microsoft.com> wrote in message
news:29D391B2-28D0-4071-9C01-80DD1C3CA561@.microsoft.com...
> I just added a new disk on a 2003 server box running sql 2000 and i want
to
> redirect my backups to the new disk (which resides on our EMC), the disk
> shows up and i was able to add it as a new resource in cluster manager but
it
> doesnt show up in sql enterprise manager. Any thoughts? Thanks

Cant upgrade to SP3 in Win Server 2003

I'm trying to install SQL Server 2000 on a newly-installed Win 2003
Server box. My disk is SQL Server SP 2. I got the error message
stating that I couldn't run SQL Server less than SP 3, but I
downloaded the patches from Microsoft's website figuring I'd install
SP 2 off the disk and then install the SP 3 from the download.

Trouble is, when I try to install SP 3, it can't authenticate the
login I give it, either the Windows logon or the sa password, to
actually install SP 3.

I've double-checked the passwords and permissions, and the Windows
logon _should_ be working, and the sa password is definitely what I'm
using in the SP 3 installation program, but no luck.

Any help would be appreciated.

Josephjbloch@.hypotenuse.com (Joe Bloch) wrote in message news:<6347ce8d.0404061048.50c0845@.posting.google.com>...
> I'm trying to install SQL Server 2000 on a newly-installed Win 2003
> Server box. My disk is SQL Server SP 2. I got the error message
> stating that I couldn't run SQL Server less than SP 3, but I
> downloaded the patches from Microsoft's website figuring I'd install
> SP 2 off the disk and then install the SP 3 from the download.
> Trouble is, when I try to install SP 3, it can't authenticate the
> login I give it, either the Windows logon or the sa password, to
> actually install SP 3.
> I've double-checked the passwords and permissions, and the Windows
> logon _should_ be working, and the sa password is definitely what I'm
> using in the SP 3 installation program, but no luck.
> Any help would be appreciated.
> Joseph

http://support.microsoft.com/defaul...4&Product=sql2k

If this doesn't help, perhaps you can give some more information. Is
the Windows account you're using for the installation a local
administrator? By default, members of that group are in the MSSQL
sysadmin role, so that should be the easiest way to avoid permissions
issues.

Simon|||sql@.hayes.ch (Simon Hayes) wrote in message news:<60cd0137.0404070042.1149c29@.posting.google.com>...
> jbloch@.hypotenuse.com (Joe Bloch) wrote in message news:<6347ce8d.0404061048.50c0845@.posting.google.com>...
> > I'm trying to install SQL Server 2000 on a newly-installed Win 2003
> > Server box. My disk is SQL Server SP 2. I got the error message
> > stating that I couldn't run SQL Server less than SP 3, but I
> > downloaded the patches from Microsoft's website figuring I'd install
> > SP 2 off the disk and then install the SP 3 from the download.
> > Trouble is, when I try to install SP 3, it can't authenticate the
> > login I give it, either the Windows logon or the sa password, to
> > actually install SP 3.
> > I've double-checked the passwords and permissions, and the Windows
> > logon _should_ be working, and the sa password is definitely what I'm
> > using in the SP 3 installation program, but no luck.
> > Any help would be appreciated.
> > Joseph
> http://support.microsoft.com/defaul...4&Product=sql2k
> If this doesn't help, perhaps you can give some more information. Is
> the Windows account you're using for the installation a local
> administrator? By default, members of that group are in the MSSQL
> sysadmin role, so that should be the easiest way to avoid permissions
> issues.
> Simon

Joseph,
Are you installing over Terminal services/remote desktop? You might
want to try VNC or use Control Panel: Add/remove programs to locate
your setup.bat file and run from there. You might also want to check
your Windows Temp and TMP Environment Variables. You need to ensure
that these variables have no spaces in the path. For example, set them
to C:/TMP and C:/TEMP instead of C:/Program files/Temp. You might
also want to locate the log file that the Service Pack writes to...you
should find the error in there! Hope this helps!
Lisa|||We're having the same issue. We have the latest MDAC installed, and
everything is fine with the registry entries and temp folders. Any
other ideas?

Thanks,

Christian

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||We're having the same issue. We have the latest MDAC installed, and
everything is fine with the registry entries and temp folders. Any
other ideas?

Thanks,

Christian

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||addernoir <addernoir> wrote in message news:<407c4f7e$0$201$75868355@.news.frii.net>...
> We're having the same issue. We have the latest MDAC installed, and
> everything is fine with the registry entries and temp folders. Any
> other ideas?
> Thanks,
> Christian
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Christian,
Have you checked the contents of SQLSP.Log ? You might find more
detail on the source of error there.|||addernoir <addernoir> wrote in message news:<407c4f7e$0$201$75868355@.news.frii.net>...
> We're having the same issue. We have the latest MDAC installed, and
> everything is fine with the registry entries and temp folders. Any
> other ideas?
> Thanks,
> Christian
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Christian,
Have you checked the contents of SQLSP.Log ? You might find more
detail on the source of error there.