Performance Counter

Hi,
Is there a way to access non Sql Server related performance counters from
Sql Server.
Like % Processor time or % Disk Time?
I'm trying to build a table to establish trends and would like to collect
all the data from via a sp.
Thx
You could try
DBCC sqlperf(THREADS)
Tobes
"ap001" <ap001@.discussions.microsoft.com> wrote in message
news:469B9D70-D7E3-452C-BAE3-2D5E0320909C@.microsoft.com...
> Hi,
> Is there a way to access non Sql Server related performance counters from
> Sql Server.
> Like % Processor time or % Disk Time?
> I'm trying to build a table to establish trends and would like to collect
> all the data from via a sp.
> Thx
>
|||Non- SQL Server perf counters are NOT stored in SQL the same way that the
SQL Counters are..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"ap001" <ap001@.discussions.microsoft.com> wrote in message
news:469B9D70-D7E3-452C-BAE3-2D5E0320909C@.microsoft.com...
> Hi,
> Is there a way to access non Sql Server related performance counters from
> Sql Server.
> Like % Processor time or % Disk Time?
> I'm trying to build a table to establish trends and would like to collect
> all the data from via a sp.
> Thx
>
|||You can write Windows performance counters to SQL Server database tables
using the Windows 2003 server or XP performance monitor tool. Create a ODBC
system DSN for your database repository and specify the DSN under log
settings. The account used for the 'Performance logs and alerts' service
needs to be granted full access to the database.
Hope this helps.
Dan Guzman
SQL Server MVP
"ap001" <ap001@.discussions.microsoft.com> wrote in message
news:469B9D70-D7E3-452C-BAE3-2D5E0320909C@.microsoft.com...
> Hi,
> Is there a way to access non Sql Server related performance counters from
> Sql Server.
> Like % Processor time or % Disk Time?
> I'm trying to build a table to establish trends and would like to collect
> all the data from via a sp.
> Thx
>
|||Thx,
I've tried this and have tested the ODBC connection which is successfull.
However when I go to start the counter log it fails and the application
event viewer has the following message:
Description:
18456 :
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
I then went and added a local group on the server and added 'NT
AUTHORITY\NETWORK SERVICE' to the group. I then granted login access for this
local group to Sql server and added it as a user to a repository db with full
permissions on the db... get the same error.
Thx again.
"Dan Guzman" wrote:

> You can write Windows performance counters to SQL Server database tables
> using the Windows 2003 server or XP performance monitor tool. Create a ODBC
> system DSN for your database repository and specify the DSN under log
> settings. The account used for the 'Performance logs and alerts' service
> needs to be granted full access to the database.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "ap001" <ap001@.discussions.microsoft.com> wrote in message
> news:469B9D70-D7E3-452C-BAE3-2D5E0320909C@.microsoft.com...
>
>
|||You might try using a domain account for the 'Performance logs and alerts'
service. This has always worked for me.
Hope this helps.
Dan Guzman
SQL Server MVP
"ap001" <ap001@.discussions.microsoft.com> wrote in message
news:2D40BCD1-40C4-4F34-B6E5-6FDDABE109FC@.microsoft.com...[vbcol=seagreen]
> Thx,
> I've tried this and have tested the ODBC connection which is successfull.
> However when I go to start the counter log it fails and the application
> event viewer has the following message:
> Description:
> 18456 :
> Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
> I then went and added a local group on the server and added 'NT
> AUTHORITY\NETWORK SERVICE' to the group. I then granted login access for
> this
> local group to Sql server and added it as a user to a repository db with
> full
> permissions on the db... get the same error.
> Thx again.
>
>
> "Dan Guzman" wrote:
|||Thx, that worked.
"Dan Guzman" wrote:

> You might try using a domain account for the 'Performance logs and alerts'
> service. This has always worked for me.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "ap001" <ap001@.discussions.microsoft.com> wrote in message
> news:2D40BCD1-40C4-4F34-B6E5-6FDDABE109FC@.microsoft.com...
>
>