SQL Server Performance Forum – Threads Archive

Logging Performance counters problem

Hi there, I’m setting up performance counters on my local PC. In my list I have counters for checking memory, physical disks, network performance, and also counters for SQL server related issues like locks, and database transactions. When I setup the performance counters I tell it to save all the stats to CSV, and that it must check every 15 seconds. When I go and check the log, only the issues relating to windows (e.g memory, physical disk, etc), have been saved. There is not even any colom headings for the SQL server related issues. I use the following SQL Server counters: SQLServer:Access Methods – Full Scans/sec. SQLServer:Buffer Manager â€“ Buffer Cache Hit Ratio. SQLServer<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />atabases – Log Growths. SQLServer<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />atabases Application Database – Percent Log Used. SQLServer<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />atabases Application Database – Transactions/sec. SQLServer:General Statistics – User Connections. SQLServer:Latches â€“ Average Latch Wait Time. SQLServer:Locks â€“ Average Wait Time. SQLServer:Locks â€“ Lock Waits/sec. SQLServer:Locks – Number of Deadlocks/sec. SQLServer:Memory Manager – Memory Grants Pending. Does anyone have an idea why this is? I mean it is my own local PC, and I am an administrator on it (for Windows and SQL Server). Any help would be appreciated, F.

Confirm the service pack level on Windows operating system and SQL Server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

1) Open Query Analyzer.
2) Run: select * from sysperinfo.
3) If table is empty check, http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6506 Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

First of all,
Windows XP Professional SP2
SQL Server SP4 Secondly,
The table is not empty. But should it not save the values of the requested counters to the CSV as I specified? Since in this format it is of no use to me (no timestamps).

I have similar configuration in my laptop, and no problem with that. After log is finished, you import data into excel and no SQL counters at all?. Shot in the dark, try with few counters first.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

what account is used to start the SQL Server service, local system or a user account

I do not import anything. When I setup my performance counters, I tell the log to save to "Text File (Comma delimited)", (other options include "Text File (Tab delimited)", "Binary File", "Binary Circular File", "SQL Database"). There is NO SQL server data in my CSV file, there is not even headings for them (for example, my windows counters have headings like: "\FRANCOISMemoryPages/sec"

Thanks joe, you kinda lead me in the right direction. When setting up the logs, under the general tab, there is a "Run as" textbox which contains <default> as default, and since I use the local system account to start SQL server, I thought that it would be fine, as it turns out, it wasn’t. I type in my credentials and now evertything is fine.

You can change the SQL Server service accounts to start with a local account with required privileges, that can help you in future too when you forget to use required credentials. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>