Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    Delhi INDIA
    Posts
    58

    Lightbulb Unanswered: Importance of sqlctr.h file

    Hi all-- there is a file in C:\Program Files\Microsoft SQL Server\MSSQL\Binn direcetory called sqlctr.h which contains a lot of counter parametres..could any one tell me having its importance and can we change any of parametres to gain performance..
    Thanks in advance..

    // This file is generated by the description file processor.
    // Please do not edit.

    #define BUFMGR_OBJECT 0
    #define BUF_RESERVED_PAGE_COUNT 2
    #define BUF_CHECKPOINT_WRITES 4
    #define BUF_AWE_LOOKUP_MAPS 6
    #define BUF_BLOCK_WRITES 8
    #define BUF_COMMITTED_PAGE_COUNT 10
    #define BUF_AWE_UNMAP_CALLS 12
    #define BUF_TARGET_PAGE_COUNT 14
    #define BUF_AWE_UNMAP_PAGES 16
    #define BUF_CACHE_RATIO_BASE 18
    #define BUF_FREELIST_STALLS 20
    #define BUF_HASHED_PAGE_COUNT 22
    #define BUF_LIFE_EXPECTANCY 24
    #define BUF_CACHE_HIT_RATIO 26
    #define BUF_AWE_WRITE_MAPS 28
    #define BUF_PAGE_REQUESTS 30
    #define BUF_STOLEN_PAGE_COUNT 32
    #define BUF_BLOCK_READS 34
    #define BUF_NUM_FREE_BUFFERS 36
    #define BUF_LAZY_WRITES 38
    #define BUF_READAHEAD_PAGES 40
    #define BUF_AWE_STOLEN_MAPS 42
    #define BUF_PROCCACHE_SIZE 44
    #define BUFPART_OBJECT 46
    #define BUFPART_NUM_FREE_BUFFERS 48
    #define BUFPART_FREE_BUFFERS_USED 50
    #define BUFPART_FREE_BUFFERS_EMPTY 52
    #define GENERAL_OBJECT 54
    #define GO_LOGINS 56
    #define GO_LOGOUTS 58
    #define GO_USER_CONNECTIONS 60
    #define LOCKS_OBJECT 62
    #define LCK_TOTAL_WAITTIME 64
    #define LCK_NUM_WAITS 66
    #define LCK_AVERAGE_WAITTIME_BASE 68
    #define LCK_NUM_DEADLOCKS 70
    #define LCK_NUM_TIMEOUTS 72
    #define LCK_NUM_REQUESTS 74
    #define LCK_AVERAGE_WAITTIME 76
    #define DBMGR_OBJECT 78
    #define DB_REPLTRANS 80
    #define DB_DBCC_SCANRATE 82
    #define DB_REPLCOUNT 84
    #define DB_LOG_SIZE 86
    #define DB_LOG_TRUNCS 88
    #define DB_LOG_USED_PERCENT 90
    #define DB_LOG_SHRINKS 92
    #define DB_BULK_KILOBYTES 94
    #define DB_FLUSH_WAIT_TIME 96
    #define DB_ACT_XTRAN 98
    #define DB_LOGCACHE_READS 100
    #define DB_FLUSH_WAITS 102
    #define DB_BCK_DB_THROUGHPUT 104
    #define DB_DBCC_MOVERATE 106
    #define DB_LOG_GROWTHS 108
    #define DB_TOTAL_XTRAN 110
    #define DB_LOGCACHE_BASE 112
    #define DB_BYTES_FLUSHED 114
    #define DB_LOG_USED 116
    #define DB_LOGCACHE_RATIO 118
    #define DB_DATA_SIZE 120
    #define DB_BULK_ROWS 122
    #define DB_FLUSHES 124
    #define LATCH_OBJECT 126
    #define LATCH_TOTAL_WAIT_NP 128
    #define LATCH_WAITS_NP 130
    #define LATCH_AVG_WAIT_NP 132
    #define LATCH_AVG_WAIT_BASE 134
    #define ACCESS_METHODS_OBJECT 136
    #define AM_EXTENTS_ALLOCATED 138
    #define AM_WORKTABLES_CREATED 140
    #define AM_GHOSTED_SKIPS 142
    #define AM_FULL_SCAN 144
    #define AM_PAGES_ALLOCATED 146
    #define AM_PAGE_SPLITS 148
    #define AM_SINGLE_PAGE_ALLOCS 150
    #define AM_EXTENTS_DEALLOCATED 152
    #define AM_PROBE_SCAN 154
    #define AM_FREESPACE_PAGES 156
    #define AM_WORKTABLES_FROM_CACHE_BASE 158
    #define AM_LOCKESCALATIONS 160
    #define AM_PAGE_DEALLOCS 162
    #define AM_WORKTABLES_FROM_CACHE 164
    #define AM_INDEX_SEARCHES 166
    #define AM_FREESPACE_SCANS 168
    #define AM_FORWARDED_RECS 170
    #define AM_WORKFILES_CREATED 172
    #define AM_SCAN_REPOSITION 174
    #define AM_RANGE_SCAN 176
    #define SQL_OBJECT 178
    #define SQL_AUTOPARAM_REQ 180
    #define SQL_BATCH_REQ 182
    #define SQL_RECOMPILES 184
    #define SQL_AUTOPARAM_UNSAFE 186
    #define SQL_COMPILES 188
    #define SQL_AUTOPARAM_FAIL 190
    #define SQL_AUTOPARAM_SAFE 192
    #define CACHE_OBJECT 194
    #define CACHE_USE_COUNT 196
    #define CACHE_HIT_RATIO_BASE 198
    #define CACHE_OBJECT_COUNT 200
    #define CACHE_HIT_RATIO 202
    #define CACHE_PGS_IN_USE 204
    #define MEMORY_OBJECT 206
    #define MEMORY_MEMGRANT_MAXIMUM 208
    #define MEMORY_CONNECTION_MEMORY 210
    #define MEMORY_MEMGRANT_WAITERS 212
    #define MEMORY_MEMGRANT_OUTSTANDING 214
    #define MEMORY_SQL_CACHE_MEMORY 216
    #define MEMORY_OPTIMIZER_MEMORY 218
    #define MEMORY_LOCKS 220
    #define MEMORY_SERVER_MEMORY 222
    #define MEMORY_LOCKOWNERS_ALLOCATED 224
    #define MEMORY_LOCK_MEMORY 226
    #define MEMORY_LOCKS_ALLOCATED 228
    #define MEMORY_SERVER_MEMORY_TARGET 230
    #define MEMORY_LOCKOWNERS 232
    #define MEMORY_MEMGRANT_ACQUIRES 234
    #define USER_QUERY_OBJECT 236
    #define QUERY_INSTANCE 238
    #define REPLICATION_AGENT_OBJECT 240
    #define RUNNING_INSTANCE 242
    #define MERGE_AGENT_OBJECT 244
    #define MERGE_CONFLICTS_INSTANCE 246
    #define UPLOAD_INSTANCE 248
    #define DOWNLOAD_INSTANCE 250
    #define LOGREADER_AGENT_OBJECT 252
    #define LOGREADER_LATENCY_INSTANCE 254
    #define LOGREADER_TRANSACTIONS_INSTANCE 256
    #define LOGREADER_COMMANDS_INSTANCE 258
    #define DISTRIBUTION_AGENT_OBJECT 260
    #define DISTRIBUTION_TRANS_INSTANCE 262
    #define DISTRIBUTION_LATENCY_INSTANCE 264
    #define DISTRIBUTION_COMMANDS_INSTANCE 266
    #define SNAPSHOT_AGENT_OBJECT 268
    #define SNAPSHOT_TRANSACTIONS_BCPED 270
    #define SNAPSHOT_COMMANDS_BCPED 272
    #define BACKUP_DEV_OBJECT 274
    #define DB_BCK_DEV_THROUGHPUT 276
    Deep..

    MCDBA
    ------------------------------------------
    How much data you can afford to lose??

  2. #2
    Join Date
    Dec 2003
    Location
    Delhi INDIA
    Posts
    58

    Thumbs down

    I did't find any information about this header file on the net also.. Pls help if any one has idea about it.
    Deep..

    MCDBA
    ------------------------------------------
    How much data you can afford to lose??

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You might check MSDN next time. The sqlctr.h file is actually a C header for the SQL Server performance counters... Changing the values in the header without recompiling SQL Server could be disasterous (then again, changing them an recompiling might even be worse)!

    -PatP

  4. #4
    Join Date
    Dec 2003
    Location
    Delhi INDIA
    Posts
    58
    Thanks Pat..
    Deep..

    MCDBA
    ------------------------------------------
    How much data you can afford to lose??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •