Performance Tuning Class on SQL2005

Does anyone know a class that concentrate or worth taking
which cover advanced performance tuning on SQL2005?
LitoI doubt such exists yet. You might want to check the Solid Quality Learning
class for SQL Server
2000 (see my signature). Vast majority applies for 2005 same way as for 2000
, where 2005 adds some
stuff to the picture.
Of course, if you already know your 2000 perf tuning stuff and are only look
ing for 2005 news, I
suggest you wait a while until things has matured.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lito D" <anonymous@.discussions.microsoft.com> wrote in message
news:136a01c5405d$16bb3170$a501280a@.phx.gbl...
> Does anyone know a class that concentrate or worth taking
> which cover advanced performance tuning on SQL2005?
> Lito

Performance Tuning Class on SQL2005

Does anyone know a class that concentrate or worth taking
which cover advanced performance tuning on SQL2005?
Lito
I doubt such exists yet. You might want to check the Solid Quality Learning class for SQL Server
2000 (see my signature). Vast majority applies for 2005 same way as for 2000, where 2005 adds some
stuff to the picture.
Of course, if you already know your 2000 perf tuning stuff and are only looking for 2005 news, I
suggest you wait a while until things has matured.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lito D" <anonymous@.discussions.microsoft.com> wrote in message
news:136a01c5405d$16bb3170$a501280a@.phx.gbl...
> Does anyone know a class that concentrate or worth taking
> which cover advanced performance tuning on SQL2005?
> Lito
sql

Performance Tuning Class on SQL2005

Does anyone know a class that concentrate or worth taking
which cover advanced performance tuning on SQL2005?
LitoI doubt such exists yet. You might want to check the Solid Quality Learning class for SQL Server
2000 (see my signature). Vast majority applies for 2005 same way as for 2000, where 2005 adds some
stuff to the picture.
Of course, if you already know your 2000 perf tuning stuff and are only looking for 2005 news, I
suggest you wait a while until things has matured.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lito D" <anonymous@.discussions.microsoft.com> wrote in message
news:136a01c5405d$16bb3170$a501280a@.phx.gbl...
> Does anyone know a class that concentrate or worth taking
> which cover advanced performance tuning on SQL2005?
> Lito

Performance Monitors Start/Stop 7AM

I have Windows 2000 Advanced Server with SQL Server 2000
Enterprise with SP3A. I trying to set up a job to import
Performance Monitors daily into SQL Server table. How
would I set up Performance Monitor to stop at 7AM close
the present file, create a new file at 7:01AM start
collecting statistics.
This would be a very help to resolve this issue.
Thank You,
Dan J.There are some utilities that come with Xp and I believe are in the resource
kit of Win2000 that should help. One is called logman.exe and the other is
relog.exe. Logman can allow you to create, start, stop, change etc your
perfmon traces and relog will import them into a sql server table.
command_logman.mspx" target="_blank">http://www.microsoft.com/resources/...and_logman.mspx
command_relog.mspx" target="_blank">http://www.microsoft.com/resources/...mand_relog.mspx
Andrew J. Kelly SQL MVP
"Dan J." <anonymous@.discussions.microsoft.com> wrote in message
news:2311001c45e99$723e0190$a601280a@.phx
.gbl...
> I have Windows 2000 Advanced Server with SQL Server 2000
> Enterprise with SP3A. I trying to set up a job to import
> Performance Monitors daily into SQL Server table. How
> would I set up Performance Monitor to stop at 7AM close
> the present file, create a new file at 7:01AM start
> collecting statistics.
> This would be a very help to resolve this issue.
> Thank You,
> Dan J.
>

Performance Monitors Start/Stop 7AM

I have Windows 2000 Advanced Server with SQL Server 2000
Enterprise with SP3A. I trying to set up a job to import
Performance Monitors daily into SQL Server table. How
would I set up Performance Monitor to stop at 7AM close
the present file, create a new file at 7:01AM start
collecting statistics.
This would be a very help to resolve this issue.
Thank You,
Dan J.
There are some utilities that come with Xp and I believe are in the resource
kit of Win2000 that should help. One is called logman.exe and the other is
relog.exe. Logman can allow you to create, start, stop, change etc your
perfmon traces and relog will import them into a sql server table.
http://www.microsoft.com/resources/d...nd_logman.mspx
http://www.microsoft.com/resources/d...and_relog.mspx
Andrew J. Kelly SQL MVP
"Dan J." <anonymous@.discussions.microsoft.com> wrote in message
news:2311001c45e99$723e0190$a601280a@.phx.gbl...
> I have Windows 2000 Advanced Server with SQL Server 2000
> Enterprise with SP3A. I trying to set up a job to import
> Performance Monitors daily into SQL Server table. How
> would I set up Performance Monitor to stop at 7AM close
> the present file, create a new file at 7:01AM start
> collecting statistics.
> This would be a very help to resolve this issue.
> Thank You,
> Dan J.
>

Performance Monitors Start/Stop 7AM

I have Windows 2000 Advanced Server with SQL Server 2000
Enterprise with SP3A. I trying to set up a job to import
Performance Monitors daily into SQL Server table. How
would I set up Performance Monitor to stop at 7AM close
the present file, create a new file at 7:01AM start
collecting statistics.
This would be a very help to resolve this issue.
Thank You,
Dan J.There are some utilities that come with Xp and I believe are in the resource
kit of Win2000 that should help. One is called logman.exe and the other is
relog.exe. Logman can allow you to create, start, stop, change etc your
perfmon traces and relog will import them into a sql server table.
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/nt_command_logman.mspx
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/nt_command_relog.mspx
--
Andrew J. Kelly SQL MVP
"Dan J." <anonymous@.discussions.microsoft.com> wrote in message
news:2311001c45e99$723e0190$a601280a@.phx.gbl...
> I have Windows 2000 Advanced Server with SQL Server 2000
> Enterprise with SP3A. I trying to set up a job to import
> Performance Monitors daily into SQL Server table. How
> would I set up Performance Monitor to stop at 7AM close
> the present file, create a new file at 7:01AM start
> collecting statistics.
> This would be a very help to resolve this issue.
> Thank You,
> Dan J.
>

Performance Monitor Data (Sysperfinfo)

I have serveral 2000 databases on a Winwords 2000 Advanced server.
I would like to collect server,processor, disk, performance data monitor
data within SQL Server.
I would like to collect the same data that you can get from perfmon but
withinQL Sever. I know SQL Server has sysperfinfo table but missing several
counters from perfmon that I would like to collect.
Please help me this issue.Hi Joe,
try using SQL profiler and set up a new trace. You can choose the data
fields you wish to see within SQL.
Hope this helps,
Isobel
"Joe K." wrote:
> I have serveral 2000 databases on a Winwords 2000 Advanced server.
> I would like to collect server,processor, disk, performance data monitor
> data within SQL Server.
> I would like to collect the same data that you can get from perfmon but
> withinQL Sever. I know SQL Server has sysperfinfo table but missing several
> counters from perfmon that I would like to collect.
> Please help me this issue.|||Nothing built in to do this with Win 2K. You can log the
Perf Mon counters to a csv and import the data into SQL
Server from there. The operating systems after 2000 have an
option to log directly to a database table but that will
have a negative impact on performance. It's generally a
better idea to log to files rather than databases and then
import the data from the files.
-Sue
On Mon, 1 May 2006 09:45:02 -0700, Joe K. <Joe
K.@.discussions.microsoft.com> wrote:
>I have serveral 2000 databases on a Winwords 2000 Advanced server.
>I would like to collect server,processor, disk, performance data monitor
>data within SQL Server.
>I would like to collect the same data that you can get from perfmon but
>withinQL Sever. I know SQL Server has sysperfinfo table but missing several
>counters from perfmon that I would like to collect.
>Please help me this issue.

Performance Monitor Data (Sysperfinfo)

I have serveral 2000 databases on a Winwords 2000 Advanced server.
I would like to collect server,processor, disk, performance data monitor
data within SQL Server.
I would like to collect the same data that you can get from perfmon but
withinQL Sever. I know SQL Server has sysperfinfo table but missing several
counters from perfmon that I would like to collect.
Please help me this issue.Hi Joe,
try using SQL profiler and set up a new trace. You can choose the data
fields you wish to see within SQL.
Hope this helps,
Isobel
"Joe K." wrote:

> I have serveral 2000 databases on a Winwords 2000 Advanced server.
> I would like to collect server,processor, disk, performance data monitor
> data within SQL Server.
> I would like to collect the same data that you can get from perfmon but
> withinQL Sever. I know SQL Server has sysperfinfo table but missing sever
al
> counters from perfmon that I would like to collect.
> Please help me this issue.|||Nothing built in to do this with Win 2K. You can log the
Perf Mon counters to a csv and import the data into SQL
Server from there. The operating systems after 2000 have an
option to log directly to a database table but that will
have a negative impact on performance. It's generally a
better idea to log to files rather than databases and then
import the data from the files.
-Sue
On Mon, 1 May 2006 09:45:02 -0700, Joe K. <Joe
K.@.discussions.microsoft.com> wrote:

>I have serveral 2000 databases on a Winwords 2000 Advanced server.
>I would like to collect server,processor, disk, performance data monitor
>data within SQL Server.
>I would like to collect the same data that you can get from perfmon but
>withinQL Sever. I know SQL Server has sysperfinfo table but missing severa
l
>counters from perfmon that I would like to collect.
>Please help me this issue.

Performance Monitor Counters Missing

All,
I am running SQL Server 2000 Enterprise Edition (SP3a +
MS03-031 patch) on Windows 2000 Advanced Server (SP3) in a
cluster using Microsoft clustering.
I am missing the Performance Monitor Counters for SQL
Server on the active node. I am not sure if the counters
were ever there. The other node was active when I did perf
monitoring before and they were present on that node then.
Any ideas?Hi,
The following article may explain the problem
812915 FIX: "Performance Monitor Shared Memory Setup Failed: -1" Error
Message
http://support.microsoft.com/?id=812915
Regards
Clive Challinor [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.