I need some help to interpret this data, I'm not a DB admin

HPamal · June 29, 2016, 2:56pm

Hi!

I need to some help to interpret this data(troubleshooting a performance issue). For the record, I'm not a DB admin, so I'll appreciate all the help I can get from you guys. My own conclusions is that the SQL server lacks resources(memory/etc).
Is it possible for me to e-mail an excel file and someone of you can have a look at it?

TaraKizer · June 30, 2016, 4:36am

Just post the Excel data here so that we can all see.

HPamal · June 30, 2016, 6:12pm

SQLServer:Buffer
Manager
Buffer cache hit ratio
1791

SQLServer:Buffer Manager
Buffer cache hit ratio base
1791

SQLServer:Buffer Manager
Page lookups/sec
1,91527E+11

SQLServer:Buffer Manager
Free list stalls/sec
2444

SQLServer:Buffer Manager
Free pages
18583

SQLServer:Buffer Manager
Total pages
1965952

SQLServer:Buffer Manager
Target pages
1965952

SQLServer:Buffer Manager
Database pages
1446865

SQLServer:Buffer Manager
Reserved pages
0

SQLServer:Buffer Manager
Stolen pages
500504

SQLServer:Buffer Manager
Lazy writes/sec
392536

SQLServer:Buffer Manager
Readahead pages/sec
206227156

SQLServer:Buffer Manager
Page reads/sec
247677220

SQLServer:Buffer Manager
Page writes/sec
93645880

SQLServer:Buffer Manager
Checkpoint pages/sec
29119825

SQLServer:Buffer Manager
AWE lookup maps/sec
0

SQLServer:Buffer Manager
AWE stolen maps/sec
0

SQLServer:Buffer Manager
AWE write maps/sec
0

SQLServer:Buffer Manager
AWE unmap calls/sec
0

SQLServer:Buffer Manager
AWE unmap pages/sec
0

SQLServer:Buffer Manager
Page life expectancy
4294045

SQLServer:Buffer Partition
Free pages
153

SQLServer:Buffer Partition
Free list requests/sec
4428375821

SQLServer:Buffer Partition
Free list empty/sec
118006488

SQLServer:Buffer Partition
Free pages
18430

SQLServer:Buffer Partition
Free list requests/sec
4341422991

SQLServer:Buffer Partition
Free list empty/sec
13557613

SQLServer:Buffer Node
Free pages
18583

SQLServer:Buffer Node
Total pages
1965952

SQLServer:Buffer Node
Foreign pages
0

SQLServer:Buffer Node
Database pages
1446865

SQLServer:Buffer Node
Stolen pages
500504

SQLServer:Buffer Node
Target pages
1965952

SQLServer:Buffer Node
Page life expectancy
4294045

SQLServer:Buffer Node
Local node page lookups/sec
0

SQLServer:Buffer Node
Remote node page lookups/sec
0

HPamal · June 30, 2016, 6:13pm

SQLServer:General
Statistics
Active Temp Tables
399

SQLServer:General Statistics
Temp Tables Creation Rate
48334

SQLServer:General Statistics
Logins/sec
38615278

SQLServer:General Statistics
Connection Reset/sec
50245378

SQLServer:General Statistics
Logouts/sec
38614579

SQLServer:General Statistics
User Connections
699

SQLServer:General Statistics
Logical Connections
701

SQLServer:General Statistics
Transactions
0

SQLServer:General Statistics
Non-atomic yield rate
42565

SQLServer:General Statistics
Mars Deadlocks
0

SQLServer:General Statistics
HTTP Authenticated Requests
0

SQLServer:General Statistics
SOAP Empty Requests
0

SQLServer:General Statistics
SOAP SQL Requests
0

SQLServer:General Statistics
SOAP Method Invocations
0

SQLServer:General Statistics
SOAP WSDL Requests
0

SQLServer:General Statistics
SOAP Session Initiate Requests
0

SQLServer:General Statistics
SOAP Session Terminate Requests
0

SQLServer:General Statistics
Processes blocked
0

SQLServer:General Statistics
Temp Tables For Destruction
0

SQLServer:General Statistics
Event Notifications Delayed Drop
0

SQLServer:General Statistics
Trace Event Notification Queue
0

SQLServer:General Statistics
SQL Trace IO Provider Lock Waits
2693

SQLServer:General Statistics
Tempdb recovery unit id
0

SQLServer:General Statistics
Tempdb rowset id
0

SQLServer:Locks
Lock Requests/sec
85409

SQLServer:Locks
Lock Timeouts/sec
2

SQLServer:Locks
Number of Deadlocks/sec
0

SQLServer:Locks
Lock Waits/sec
2

SQLServer:Locks
Lock Wait Time (ms)
48

SQLServer:Locks
Average Wait Time (ms)
48

SQLServer:Locks
Average Wait Time Base
2

SQLServer:Locks
Lock Timeouts (timeout > 0)/sec
0

SQLServer:Locks
Lock Requests/sec
445091600

SQLServer:Locks
Lock Timeouts/sec
0

SQLServer:Locks
Number of Deadlocks/sec
0

SQLServer:Locks
Lock Waits/sec
0

SQLServer:Locks
Lock Wait Time (ms)
0

SQLServer:Locks
Average Wait Time (ms)
0

SQLServer:Locks
Average Wait Time Base
0

SQLServer:Locks
Lock Timeouts (timeout > 0)/sec
0

SQLServer:Locks
Lock Requests/sec
863936326

SQLServer:Locks
Lock Timeouts/sec
6

SQLServer:Locks
Number of Deadlocks/sec
0

SQLServer:Locks
Lock Waits/sec
437

SQLServer:Locks
Lock Wait Time (ms)
38942

SQLServer:Locks
Average Wait Time (ms)
38942

SQLServer:Locks
Average Wait Time Base
437

SQLServer:Locks
Lock Timeouts (timeout > 0)/sec
0

SQLServer:Locks
Lock Requests/sec
0

SQLServer:Locks
Lock Timeouts/sec
0

SQLServer:Locks
Number of Deadlocks/sec
0

SQLServer:Locks
Lock Waits/sec
0

SQLServer:Locks
Lock Wait Time (ms)
0

SQLServer:Locks
Average Wait Time (ms)
0

SQLServer:Locks
Average Wait Time Base
0

SQLServer:Locks
Lock Timeouts (timeout > 0)/sec
0

SQLServer:Locks
Lock Requests/sec
8014007060

HPamal · June 30, 2016, 6:13pm

SQLServer:Locks
Lock Timeouts/sec
259

SQLServer:Locks
Number of Deadlocks/sec
0

SQLServer:Locks
Lock Waits/sec
8

SQLServer:Locks
Lock Wait Time (ms)
1013

SQLServer:Locks
Average Wait Time (ms)
1013

SQLServer:Locks
Average Wait Time Base
8

SQLServer:Locks
Lock Timeouts (timeout > 0)/sec
0

SQLServer:Locks
Lock Requests/sec
198229740

SQLServer:Locks
Lock Timeouts/sec
19091

SQLServer:Locks
Number of Deadlocks/sec
0

SQLServer:Locks
Lock Waits/sec
0

SQLServer:Locks
Lock Wait Time (ms)
0

SQLServer:Locks
Average Wait Time (ms)
0

SQLServer:Locks
Average Wait Time Base
0

SQLServer:Locks
Lock Timeouts (timeout > 0)/sec
0

SQLServer:Locks
Lock Requests/sec
1,33016E+11

SQLServer:Locks
Lock Timeouts/sec
31426079

SQLServer:Locks
Number of Deadlocks/sec
713

SQLServer:Locks
Lock Waits/sec
16527

SQLServer:Locks
Lock Wait Time (ms)
1116135

SQLServer:Locks
Average Wait Time (ms)
1116135

SQLServer:Locks
Average Wait Time Base
16527

SQLServer:Locks
Lock Timeouts (timeout > 0)/sec
0

SQLServer:Locks
Lock Requests/sec
76595398006

SQLServer:Locks
Lock Timeouts/sec
640012

SQLServer:Locks
Number of Deadlocks/sec
0

SQLServer:Locks
Lock Waits/sec
492

SQLServer:Locks
Lock Wait Time (ms)
20355

SQLServer:Locks
Average Wait Time (ms)
20355

SQLServer:Locks
Average Wait Time Base
492

SQLServer:Locks
Lock Timeouts (timeout > 0)/sec
0

SQLServer:Locks
Lock Requests/sec
7747329790

SQLServer:Locks
Lock Timeouts/sec
97298

SQLServer:Locks
Number of Deadlocks/sec
0

SQLServer:Locks
Lock Waits/sec
4278

SQLServer:Locks
Lock Wait Time (ms)
4124876

SQLServer:Locks
Average Wait Time (ms)
4124876

SQLServer:Locks
Average Wait Time Base
4278

SQLServer:Locks
Lock Timeouts (timeout > 0)/sec
0

SQLServer:Locks
Lock Requests/sec
179668

SQLServer:Locks
Lock Timeouts/sec
0

SQLServer:Locks
Number of Deadlocks/sec
0

SQLServer:Locks
Lock Waits/sec
163

SQLServer:Locks
Lock Wait Time (ms)
23042

SQLServer:Locks
Average Wait Time (ms)
23042

SQLServer:Locks
Average Wait Time Base
163

SQLServer:Locks
Lock Timeouts (timeout > 0)/sec
0

SQLServer:Locks
Lock Requests/sec
189981906

SQLServer:Locks
Lock Timeouts/sec
256

SQLServer:Locks
Number of Deadlocks/sec
0

SQLServer:Locks
Lock Waits/sec
181

SQLServer:Locks
Lock Wait Time (ms)
18716

SQLServer:Locks
Average Wait Time (ms)
18716

SQLServer:Locks
Average Wait Time Base
181

SQLServer:Locks
Lock Timeouts (timeout > 0)/sec
2

SQLServer:Locks
Lock Requests/sec
2,27071E+11

SQLServer:Locks
Lock Timeouts/sec
32183003

SQLServer:Locks
Number of Deadlocks/sec
713

SQLServer:Locks
Lock Waits/sec
22088

SQLServer:Locks
Lock Wait Time (ms)
5343127

SQLServer:Locks
Average Wait Time (ms)
5343127

SQLServer:Locks
Average Wait Time Base
22088

SQLServer:Locks
Lock Timeouts (timeout > 0)/sec
2

SQLServer:Databases
Data File(s) Size (KB)
15360

SQLServer:Databases
Log File(s) Size (KB)
6712

SQLServer:Databases
Log File(s) Used Size (KB)
1637

SQLServer:Databases
Percent Log Used
24

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
146773

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
9

SQLServer:Databases
Log Cache Hit Ratio
4

SQLServer:Databases
Log Cache Hit Ratio Base
9

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
101305344

SQLServer:Databases
DBCC Logical Scan Bytes/sec
113647616

SQLServer:Databases
Shrink Data Movement Bytes/sec
0

SQLServer:Databases
Log Flushes/sec
120416

SQLServer:Databases
Log Bytes Flushed/sec
91518464

SQLServer:Databases
Log Flush Waits/sec
120261

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
41

SQLServer:Databases
Log Growths
5

SQLServer:Databases
Log Shrinks
0

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
120090

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
3763776

SQLServer:Databases
Log File(s) Size (KB)
1045624

SQLServer:Databases
Log File(s) Used Size (KB)
57856

SQLServer:Databases
Percent Log Used
5

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
3214

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
134

SQLServer:Databases
Log Cache Hit Ratio
118

SQLServer:Databases
Log Cache Hit Ratio Base
134

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
0

SQLServer:Databases
DBCC Logical Scan Bytes/sec
8429568

SQLServer:Databases
Shrink Data Movement Bytes/sec
57344

SQLServer:Databases
Log Flushes/sec
1544

SQLServer:Databases
Log Bytes Flushed/sec
50897920

SQLServer:Databases
Log Flush Waits/sec
707

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
8

SQLServer:Databases
Log Growths
0

SQLServer:Databases
Log Shrinks
6

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
651

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
3072

SQLServer:Databases
Log File(s) Size (KB)
4088

SQLServer:Databases
Log File(s) Used Size (KB)
1137

SQLServer:Databases
Percent Log Used
27

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
4842

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
9

SQLServer:Databases
Log Cache Hit Ratio
4

SQLServer:Databases
Log Cache Hit Ratio Base
9

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
38904832

SQLServer:Databases
DBCC Logical Scan Bytes/sec
63848448

SQLServer:Databases
Shrink Data Movement Bytes/sec
0

SQLServer:Databases
Log Flushes/sec
4065

SQLServer:Databases
Log Bytes Flushed/sec
5022720

SQLServer:Databases
Log Flush Waits/sec
4061

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
1

SQLServer:Databases
Log Growths
0

SQLServer:Databases
Log Shrinks
0

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
3853

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
3072

SQLServer:Databases
Log File(s) Size (KB)
4088

SQLServer:Databases
Log File(s) Used Size (KB)
963

SQLServer:Databases
Percent Log Used
23

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
5684

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
9

SQLServer:Databases
Log Cache Hit Ratio
4

SQLServer:Databases
Log Cache Hit Ratio Base
9

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
53262336

SQLServer:Databases
DBCC Logical Scan Bytes/sec
85229568

SQLServer:Databases
Shrink Data Movement Bytes/sec
0

SQLServer:Databases
Log Flushes/sec
4676

SQLServer:Databases
Log Bytes Flushed/sec
5819904

SQLServer:Databases
Log Flush Waits/sec
4672

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
1

SQLServer:Databases
Log Growths
0

SQLServer:Databases
Log Shrinks
0

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
4388

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
2836480

SQLServer:Databases
Log File(s) Size (KB)
1913912

SQLServer:Databases
Log File(s) Used Size (KB)
10812

SQLServer:Databases
Percent Log Used
0

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
744019

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
718807

SQLServer:Databases
Log Cache Hit Ratio
709416

SQLServer:Databases
Log Cache Hit Ratio Base
718807

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
54582366208

SQLServer:Databases
DBCC Logical Scan Bytes/sec
16302080

SQLServer:Databases
Shrink Data Movement Bytes/sec
0

SQLServer:Databases
Log Flushes/sec
622176

SQLServer:Databases
Log Bytes Flushed/sec
11039936512

SQLServer:Databases
Log Flush Waits/sec
451140

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
8

SQLServer:Databases
Log Growths
81

SQLServer:Databases
Log Shrinks
6

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
448140

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
5146624

SQLServer:Databases
Log File(s) Size (KB)
3562872

SQLServer:Databases
Log File(s) Used Size (KB)
13296

SQLServer:Databases
Percent Log Used
0

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
4087435

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
1179213

SQLServer:Databases
Log Cache Hit Ratio
1162762

SQLServer:Databases
Log Cache Hit Ratio Base
1179213

SQLServer:Databases
Bulk Copy Rows/sec
3559

SQLServer:Databases
Bulk Copy Throughput/sec
588

SQLServer:Databases
Backup/Restore Throughput/sec
1,42486E+11

SQLServer:Databases
DBCC Logical Scan Bytes/sec
40542208

SQLServer:Databases
Shrink Data Movement Bytes/sec
2184

SQLServer:Databases
Log Flushes/sec
3585210

SQLServer:Databases
Log Bytes Flushed/sec
26962165760

SQLServer:Databases
Log Flush Waits/sec
3178996

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
12

SQLServer:Databases
Log Growths
156

SQLServer:Databases
Log Shrinks
9

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
3173419

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
2688

SQLServer:Databases
Log File(s) Size (KB)
6407928

SQLServer:Databases
Log File(s) Used Size (KB)
96574

SQLServer:Databases
Percent Log Used
1

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
881

SQLServer:Databases
Repl. Pending Xacts
4226811

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
340

SQLServer:Databases
Log Cache Hit Ratio
318

SQLServer:Databases
Log Cache Hit Ratio Base
340

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
0

SQLServer:Databases
DBCC Logical Scan Bytes/sec
2973696

SQLServer:Databases
Shrink Data Movement Bytes/sec
57344

SQLServer:Databases
Log Flushes/sec
425

SQLServer:Databases
Log Bytes Flushed/sec
5336064

SQLServer:Databases
Log Flush Waits/sec
337

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
16

SQLServer:Databases
Log Growths
0

SQLServer:Databases
Log Shrinks
12

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
283

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
447872

SQLServer:Databases
Log File(s) Size (KB)
1272

SQLServer:Databases
Log File(s) Used Size (KB)
393

SQLServer:Databases
Percent Log Used
30

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
347696

SQLServer:Databases
Repl. Pending Xacts
580121056

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
44234

SQLServer:Databases
Log Cache Hit Ratio
43316

SQLServer:Databases
Log Cache Hit Ratio Base
44234

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
15353394176

SQLServer:Databases
DBCC Logical Scan Bytes/sec
1790500864

SQLServer:Databases
Shrink Data Movement Bytes/sec
32628974

SQLServer:Databases
Log Flushes/sec
100486

SQLServer:Databases
Log Bytes Flushed/sec
1564232192

SQLServer:Databases
Log Flush Waits/sec
79386

SQLServer:Databases
Log Flush Wait Time
16

SQLServer:Databases
Log Truncations
418

SQLServer:Databases
Log Growths
355

SQLServer:Databases
Log Shrinks
273

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
78616

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
43968

SQLServer:Databases
Log File(s) Size (KB)
29496

SQLServer:Databases
Log File(s) Used Size (KB)
3849

SQLServer:Databases
Percent Log Used
13

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
2942

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
615

SQLServer:Databases
Log Cache Hit Ratio
598

SQLServer:Databases
Log Cache Hit Ratio Base
615

SQLServer:Databases
Bulk Copy Rows/sec
4980

SQLServer:Databases
Bulk Copy Throughput/sec
372

SQLServer:Databases
Backup/Restore Throughput/sec
0

SQLServer:Databases
DBCC Logical Scan Bytes/sec
8208384

SQLServer:Databases
Shrink Data Movement Bytes/sec
0

SQLServer:Databases
Log Flushes/sec
2338

SQLServer:Databases
Log Bytes Flushed/sec
3646464

SQLServer:Databases
Log Flush Waits/sec
2327

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
2

SQLServer:Databases
Log Growths
0

SQLServer:Databases
Log Shrinks
0

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
2273

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
5120

SQLServer:Databases
Log File(s) Size (KB)
29496

SQLServer:Databases
Log File(s) Used Size (KB)
2934

SQLServer:Databases
Percent Log Used
9

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
136

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
13

SQLServer:Databases
Log Cache Hit Ratio
8

SQLServer:Databases
Log Cache Hit Ratio Base
13

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
0

SQLServer:Databases
DBCC Logical Scan Bytes/sec
0

SQLServer:Databases
Shrink Data Movement Bytes/sec
0

SQLServer:Databases
Log Flushes/sec
21

SQLServer:Databases
Log Bytes Flushed/sec
14848

SQLServer:Databases
Log Flush Waits/sec
21

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
0

SQLServer:Databases
Log Growths
0

SQLServer:Databases
Log Shrinks
0

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
19

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
3072

SQLServer:Databases
Log File(s) Size (KB)
4088

SQLServer:Databases
Log File(s) Used Size (KB)
1541

SQLServer:Databases
Percent Log Used
37

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
11510

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
13

SQLServer:Databases
Log Cache Hit Ratio
8

SQLServer:Databases
Log Cache Hit Ratio Base
13

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
113034240

SQLServer:Databases
DBCC Logical Scan Bytes/sec
173555712

SQLServer:Databases
Shrink Data Movement Bytes/sec
0

SQLServer:Databases
Log Flushes/sec
10059

SQLServer:Databases
Log Bytes Flushed/sec
11931136

SQLServer:Databases
Log Flush Waits/sec
10044

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
0

SQLServer:Databases
Log Growths
0

SQLServer:Databases
Log Shrinks
0

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
9563

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
9216

SQLServer:Databases
Log File(s) Size (KB)
4088

SQLServer:Databases
Log File(s) Used Size (KB)
1814

SQLServer:Databases
Percent Log Used
44

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
9930

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
13

SQLServer:Databases
Log Cache Hit Ratio
8

SQLServer:Databases
Log Cache Hit Ratio Base
13

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
191546368

SQLServer:Databases
DBCC Logical Scan Bytes/sec
247013376

SQLServer:Databases
Shrink Data Movement Bytes/sec
0

SQLServer:Databases
Log Flushes/sec
8088

SQLServer:Databases
Log Bytes Flushed/sec
18092544

SQLServer:Databases
Log Flush Waits/sec
8025

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
0

SQLServer:Databases
Log Growths
0

SQLServer:Databases
Log Shrinks
0

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
7544

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
4096

SQLServer:Databases
Log File(s) Size (KB)
4088

SQLServer:Databases
Log File(s) Used Size (KB)
550

SQLServer:Databases
Percent Log Used
13

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
13410

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
13

SQLServer:Databases
Log Cache Hit Ratio
8

SQLServer:Databases
Log Cache Hit Ratio Base
13

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
167494656

SQLServer:Databases
DBCC Logical Scan Bytes/sec
229130240

HPamal · June 30, 2016, 6:13pm

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
909

SQLServer:Databases
Log Cache Hit Ratio
754

SQLServer:Databases
Log Cache Hit Ratio Base
909

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
83797497856

SQLServer:Databases
DBCC Logical Scan Bytes/sec
63643648

SQLServer:Databases
Shrink Data Movement Bytes/sec
588

SQLServer:Databases
Log Flushes/sec
915806

SQLServer:Databases
Log Bytes Flushed/sec
8367664128

SQLServer:Databases
Log Flush Waits/sec
784058

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
24

SQLServer:Databases
Log Growths
123

SQLServer:Databases
Log Shrinks
18

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
783514

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
1564672

SQLServer:Databases
Log File(s) Size (KB)
1456888

SQLServer:Databases
Log File(s) Used Size (KB)
9810

SQLServer:Databases
Percent Log Used
0

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
1156512

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
1373

SQLServer:Databases
Log Cache Hit Ratio
994

SQLServer:Databases
Log Cache Hit Ratio Base
1373

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
76562384896

SQLServer:Databases
DBCC Logical Scan Bytes/sec
49840128

SQLServer:Databases
Shrink Data Movement Bytes/sec
13440

SQLServer:Databases
Log Flushes/sec
828066

SQLServer:Databases
Log Bytes Flushed/sec
11186356224

SQLServer:Databases
Log Flush Waits/sec
656738

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
22

SQLServer:Databases
Log Growths
139

SQLServer:Databases
Log Shrinks
16

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
656241

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
2102272

SQLServer:Databases
Log File(s) Size (KB)
2057144

SQLServer:Databases
Log File(s) Used Size (KB)
10474

SQLServer:Databases
Percent Log Used
0

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
1066039

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
1288

SQLServer:Databases
Log Cache Hit Ratio
937

SQLServer:Databases
Log Cache Hit Ratio Base
1288

SQLServer:Databases
Bulk Copy Rows/sec
31829

SQLServer:Databases
Bulk Copy Throughput/sec
15902

SQLServer:Databases
Backup/Restore Throughput/sec
1,0201E+11

SQLServer:Databases
DBCC Logical Scan Bytes/sec
52445184

HPamal · June 30, 2016, 6:13pm

SQLServer:Databases
Shrink Data Movement Bytes/sec
0

SQLServer:Databases
Log Flushes/sec
11983

SQLServer:Databases
Log Bytes Flushed/sec
13220864

SQLServer:Databases
Log Flush Waits/sec
11975

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
0

SQLServer:Databases
Log Growths
0

SQLServer:Databases
Log Shrinks
0

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
11494

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
1302528

SQLServer:Databases
Log File(s) Size (KB)
926520

SQLServer:Databases
Log File(s) Used Size (KB)
13307

SQLServer:Databases
Percent Log Used
1

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
34387139

SQLServer:Databases
Repl. Pending Xacts
0

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
671

SQLServer:Databases
Log Cache Hit Ratio
638

SQLServer:Databases
Log Cache Hit Ratio Base
671

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
85058087936

SQLServer:Databases
DBCC Logical Scan Bytes/sec
61865984

SQLServer:Databases
Shrink Data Movement Bytes/sec
0

SQLServer:Databases
Log Flushes/sec
26382673

SQLServer:Databases
Log Bytes Flushed/sec
29462352384

SQLServer:Databases
Log Flush Waits/sec
26301540

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
24

SQLServer:Databases
Log Growths
31

SQLServer:Databases
Log Shrinks
18

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
26295133

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
4992

SQLServer:Databases
Log File(s) Size (KB)
35704

SQLServer:Databases
Log File(s) Used Size (KB)
32689

SQLServer:Databases
Percent Log Used
91

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
13513

SQLServer:Databases
Repl. Pending Xacts
4226811

SQLServer:Databases
Repl. Trans. Rate
0

SQLServer:Databases
Log Cache Reads/sec
13

SQLServer:Databases
Log Cache Hit Ratio
8

SQLServer:Databases
Log Cache Hit Ratio Base
13

SQLServer:Databases
Bulk Copy Rows/sec
0

SQLServer:Databases
Bulk Copy Throughput/sec
0

SQLServer:Databases
Backup/Restore Throughput/sec
218605568

SQLServer:Databases
DBCC Logical Scan Bytes/sec
278650880

SQLServer:Databases
Shrink Data Movement Bytes/sec
0

SQLServer:Databases
Log Flushes/sec
12104

SQLServer:Databases
Log Bytes Flushed/sec
16431616

SQLServer:Databases
Log Flush Waits/sec
12074

SQLServer:Databases
Log Flush Wait Time
0

SQLServer:Databases
Log Truncations
0

SQLServer:Databases
Log Growths
8

SQLServer:Databases
Log Shrinks
0

SQLServer:Databases
Tracked transactions/sec
0

SQLServer:Databases
Write Transactions/sec
11592

SQLServer:Databases
Commit table entries
0

SQLServer:Databases
Data File(s) Size (KB)
1728384

SQLServer:Databases
Log File(s) Size (KB)
672824

SQLServer:Databases
Log File(s) Used Size (KB)
21765

SQLServer:Databases
Percent Log Used
3

SQLServer:Databases
Active Transactions
0

SQLServer:Databases
Transactions/sec
1352221

SQLServer:Databases
Repl. Pending Xacts
49476088

TaraKizer · June 30, 2016, 8:52pm

That's just a bunch of PerfMon counters and their values. What does your waits show? What specifically is making you think you have a resource issue?

sqlprogrammers · July 7, 2016, 5:32am

Please provide more information about the issue.