Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

1

2

6850

_wait CXPACKET ms

516

1088079

305077.133

0

0

34

_wait SOS_SCHEDULER_YIELD ms

0

989615

220516.683

0

0

309

_wait PAGEIOLATCH_SH ms

1

426620

142992.383

49

122

111001

_wait LAZYWRITER_SLEEP ms

13781

228350

90811.583

100

322

191719

_wait CHECKPOINT_QUEUE ms

0

191719

59546.900

20

50

30377

_wait SLEEP_TASK ms

29880

154256

60648.133

98

106

140567

_wait WAITFOR ms

78901

143902

132305.983

67

409

83084

_wait DISPATCHER_QUEUE_SEMAPHORE ms

0

123101

20329.571

95

1400

102144

_wait ASYNC_IO_COMPLETION ms

0

107446

7295.021

0

0

0

_wait LCK_M_SCH_S ms

0

86080

21517.200

0

0

0

_wait LCK_M_S ms

0

82302

7395.317

67

467

54887

_wait BACKUPIO ms

0

81571

11741.782

0

0

0

_wait PAGELATCH_EX ms

0

75065

27995.914

0

0

66

_wait PAGEIOLATCH_EX ms

0

75046

21932.883

74

607

45004

_wait BACKUPBUFFER ms

0

60561

7411.391

99

100

59953

_wait XE_TIMER_EVENT ms

59556

60388

59999.417

99

100

59994

_wait REQUEST_FOR_DEADLOCK_SEARCH ms

59530

60379

59997.050

100

100

60018

_wait SQLTRACE_INCREMENTAL_FLUSH_SLEEP ms

59677

60231

59995.800

99

100

59906

_wait XE_DISPATCHER_WAIT ms

59806

60210

60002.333

100

101

59909

_wait FT_IFTS_SCHEDULER_IDLE_WAIT ms

54006

60207

59508.583

99

100

59901

_wait SP_SERVER_DIAGNOSTICS_SLEEP ms

59803

60203

60001.350

100

100

59943

_wait HADR_FILESTREAM_IOMGR_IOCOMPLETION ms

59901

60159

60000.200

100

100

59931

_wait DIRTY_PAGE_POLL ms

59902

60121

59998.117

100

100

59937

_wait LOGMGR_QUEUE ms

59728

60089

59944.117

0

0

42

_wait LATCH_EX ms

1

40831

14314.706

100

100

29969

_wait BROKER_TO_FLUSH ms

29909

30077

29998.317

0

0

9

_wait ASYNC_NETWORK_IO ms

6

28798

11255.400

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

63

369

17957333134

mf> num_of_bytes_read

854210

28282109952

4865214450.483

63

390

17957211685

mfDESC> ROWS num_of_bytes_read

854210

28282109952

4600860540.800

0

1

19103445

mf> num_of_bytes_written

450150

6797109901

1336210324.733

0

2

17938436

mfDESC> ROWS num_of_bytes_written

819

4766035855

1006328044.083

0

0

121448

mfDESC> LOG num_of_bytes_read

0

3325394944

264353909.383

0

0

1165008

mfDESC> LOG num_of_bytes_written

449331

2031074045

329882280.217

0

0

63

mf> io_stall_write_ms

15

639279

155788.433

0

0

46

mfDESC> ROWS io_stall_write_ms

0

629476

151475.633

17

44

101105

mf> io_stall_read_ms

213

591812

228864.483

18

44

101104

mfDESC> ROWS io_stall_read_ms

213

574503

227275.633

0

1

321

mf> num_of_writes

10

134790

44921.683

0

1

287

mfDESC> ROWS num_of_writes

0

115462

38293.800

16

45

17452

mf> num_of_reads

18

107108

39176.200

16

45

17452

mfDESC> ROWS num_of_reads

18

107056

38804.167

0

1

34

mfDESC> LOG num_of_writes

10

40390

6627.450

0

0

1

mfDESC> LOG io_stall_read_ms

0

19999

1588.633

0

0

17

mfDESC> LOG io_stall_write_ms

13

16102

4312.317

0

0

0

mfDESC> LOG num_of_reads

0

3522

371.900

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

2

11

977207

Probe Scans/sec|SQLServer:Access Methods|

2464

39311234

9183020.550

3

12

1001000

Index Searches/sec|SQLServer:Access Methods|

7121

36562673

8144796.750

0

0

17706

Range Scans/sec|SQLServer:Access Methods|

457

18559490

3739499.183

0

0

239

Full Scans/sec|SQLServer:Access Methods|

98

1231926

328514.283

1

5

6514

Pages Allocated/sec|SQLServer:Access Methods|

724

488518

128596.900

1

5

6523

Page Deallocations/sec|SQLServer:Access Methods|

740

481101

121832.467

13

61

59737

Used leaf page cookie|SQLServer:Access Methods|

0

443950

98381.367

0

0

52

Skipped Ghosted Records/sec|SQLServer:Access Methods|

7

353605

66403.083

2

8

4051

FreeSpace Page Fetches/sec|SQLServer:Access Methods|

574

173818

49490.033

0

0

0

Used tree page cookie|SQLServer:Access Methods|

0

131203

34524.750

3

11

4051

FreeSpace Scans/sec|SQLServer:Access Methods|

574

117191

36472.400

0

0

10

Scan Point Revalidations/sec|SQLServer:Access Methods|

3

68959

17855.433

1

2

376

Workfiles Created/sec|SQLServer:Access Methods|

50

62063

20744.150

1

5

681

Extents Allocated/sec|SQLServer:Access Methods|

93

57507

14598.967

1

6

807

Extent Deallocations/sec|SQLServer:Access Methods|

94

57203

13930.767

0

1

123

Mixed page allocations/sec|SQLServer:Access Methods|

26

34844

10154.217

37

92

10692

Count Lob Readahead|SQLServer:Access Methods|

54

28640

11637.517

0

1

27

Page Splits/sec|SQLServer:Access Methods|

21

16750

4721.017

0

1

66

Worktables Created/sec|SQLServer:Access Methods|

15

14607

4896.083

0

0

0

Failed leaf page cookie|SQLServer:Access Methods|

0

8390

273.300

4

16

27

LobHandle Create Count|SQLServer:Access Methods|

6

737

167.483

2

8

4

AU cleanup batches/sec|SQLServer:Access Methods|

0

187

49.183

1

9

1

LobSS Provider Create Count|SQLServer:Access Methods|

0

107

11.167

1

9

1

LobSS Provider Destroy Count|SQLServer:Access Methods|

0

107

11.167

0

0

0

LobSS Provider Truncation Count|SQLServer:Access Methods|

0

92

5.933

0

0

0

Forwarded Records/sec|SQLServer:Access Methods|

0

40

10.167

0

0

0

AU cleanups/sec|SQLServer:Access Methods|

0

23

5.917

85

153

17

LobHandle Destroy Count|SQLServer:Access Methods|

0

20

11.133

0

0

0

Failed tree page cookie|SQLServer:Access Methods|

0

6

0.200

0

0

0

Deferred dropped AUs|SQLServer:Access Methods|

0

5

0.317

0

0

0

Count Push Off Row|SQLServer:Access Methods|

0

1

0.033

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

100

101

31893440

Free Space in tempdb (KB)|SQLServer:Transactions|

30688128

31962176

31559218.133

0

1

2745

Transactions/sec|SQLServer:Databases|_Total

254

955860

205298.933

0

0

144

Version Store Size (KB)|SQLServer:Transactions|

136

788096

145896.000

0

0

138

Version Cleanup rate (KB/s)|SQLServer:Transactions|

21

266229

68535.833

0

0

138

Version Generation rate (KB/s)|SQLServer:Transactions|

35

246324

68533.367

0

1

173

Write Transactions/sec|SQLServer:Databases|_Total

50

125902

25852.433

100

129

1152

Version Store unit creation|SQLServer:Transactions|

655

1152

890.800

100

130

1150

Version Store unit truncation|SQLServer:Transactions|

653

1150

887.867

2

8

9

Transactions|SQLServer:Transactions|

9

466

106.450

0

0

0

Longest Transaction Running Time|SQLServer:Transactions|

0

446

33.367

0

0

0

Active Transactions|SQLServer:Databases|_Total

0

61

15.983

2

7

1

Transactions|SQLServer:General Statistics|

1

52

13.850

0

0

0

NonSnapshot Version Transactions|SQLServer:Transactions|

0

43

12.483

22

68

2

Version Store unit count|SQLServer:Transactions|

2

9

2.933

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

4

13

9466

Batch Requests/sec|SQLServer:SQL Statistics|

1108

238946

73656.867

0

1

125

SQL Compilations/sec|SQLServer:SQL Statistics|

32

54824

15869.517

0

1

16

SQL Re-Compilations/sec|SQLServer:SQL Statistics|

9

3765

1109.617

1

3

8

par> Auto-Param Attempts/sec|SQLServer:SQL Statistics|

6

979

271.000

1

3

8

par> Failed Auto-Params/sec|SQLServer:SQL Statistics|

6

978

270.500

0

0

0

SQL Attention rate|SQLServer:SQL Statistics|

0

26

1.250

0

0

0

par> Unsafe Auto-Params/sec|SQLServer:SQL Statistics|

0

1

0.017

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

0

0

418

Total Latch Wait Time (ms)|SQLServer:Latches|

6

610093

195943.983

0

1

242

Latch Waits/sec|SQLServer:Latches|

98

137198

44553.050

99

148

3752

Number of SuperLatches|SQLServer:Latches|

1118

3792

2542.000

0

0

0

SuperLatch Promotions/sec|SQLServer:Latches|

0

73

9.700

0

0

0

SuperLatch Demotions/sec|SQLServer:Latches|

0

25

5.950

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

0

1

74977

Lock Requests/sec|SQLServer:Locks|_Total

34163

27436801

7809891.517

8

32

29967

Lock Owner Blocks|SQLServer:Memory Manager|

3759

355595

93676.017

8

31

29006

Lock Blocks|SQLServer:Memory Manager|

3758

354268

92677.450

0

0

1

Lock Timeouts/sec|SQLServer:Locks|_Total

0

189151

50537.483

0

0

45

Lock Wait Time (ms)|SQLServer:Locks|_Total

0

144322

29535.050

0

0

0

Lock Waits/sec|SQLServer:Locks|_Total

0

12

1.883

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

7

21

9492

@@PACK_RECEIVED

1116

143725

44758.717

7

22

10156

@@PACK_SENT

1475

142278

45726.733

0

1

321

@@TOTAL_WRITE

10

134789

44921.700

16

45

17452

@@TOTAL_READ

18

107109

39181.167

98

114

102471

@@idle

61081

104936

89692.917

5

15

2360

@@cpu_busy

80

43806

15228.917

5

59

13

@@connections

10

241

22.167

33

77

59

@@io_busy

1

178

77.000

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

100

116

103479286

Batches >=001000ms & <002000ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

79664954

103479286

89394827.733

99

100

93098040

Total Server Memory (KB)|SQLServer:Memory Manager|

78798120

93885848

92875305.867

99

100

93098024

Total Node Memory (KB)|SQLServer:Memory Node|000

78798096

93885832

92875289.733

100

100

67108560

Database Cache Memory (KB)|SQLServer:Memory Manager|

67104336

67112584

67108756.267

100

100

67108560

Database Node Memory (KB)|SQLServer:Memory Node|000

67104336

67112584

67108758.400

100

187

66448822

Batches >=005000ms & <010000ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

4507868

66448822

35494815.533

100

204

50949299

Batches >=000500ms & <001000ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

6672571

50949299

24979497.900

100

190

33917522

Batches >=000200ms & <000500ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

5980621

33917522

17865992.933

100

173

28397744

Batches >=002000ms & <005000ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

7268258

28397744

16401377.683

100

184

23282172

Batches >=010000ms & <020000ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

3662540

23282172

12637127.400

63

86

14303824

Free Memory (KB)|SQLServer:Memory Manager|

8043144

22569856

16642711.067

63

86

14303824

Free Node Memory (KB)|SQLServer:Memory Node|000

8043144

22569856

16642712.400

100

180

22052637

Batches >=000050ms & <000100ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

4789023

22052637

12238317.050

100

211

21259022

Batches >=000100ms & <000200ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

1716412

21259022

10067641.933

100

108

18057989

Batches >=100000ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

15163873

18057989

16697135.483

100

197

14965688

Batches >=000020ms & <000050ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

1796302

14965688

7608465.050

97

128

11685640

Stolen Node Memory (KB)|SQLServer:Memory Node|000

3599808

12075648

9123818.933

97

128

11685656

Stolen Server Memory (KB)|SQLServer:Memory Manager|

3599832

12075616

9123837.733

100

103

10336546

Batches >=020000ms & <050000ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

9931747

10336546

10072120.450

100

178

5999683

Batches >=000010ms & <000020ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

1308502

5999683

3375010.283

100

140

4866310

Batches >=000005ms & <000010ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

2433497

4866310

3484859.833

100

147

2978419

Batches >=000002ms & <000005ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

1281689

2978419

2028767.367

100

107

2611899

Batches >=050000ms & <100000ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

2096912

2611899

2430128.550

100

158

921605

Batches >=000001ms & <000002ms|SQLServer:Batch Resp Statistics|CPU Time:Total(ms)

293451

921605

583997.333

0

0

0

Granted Workspace Memory (KB)|SQLServer:Memory Manager|

0

508864

59681.200

0

0

0

Reserved Server Memory (KB)|SQLServer:Memory Manager|

0

464544

47663.333

8

32

29967

Lock Owner Blocks|SQLServer:Memory Manager|

3759

355595

93676.017

8

31

29006

Lock Blocks|SQLServer:Memory Manager|

3758

354268

92677.450

84

146

168144

SQL Cache Memory (KB)|SQLServer:Memory Manager|

2360

200488

115013.200

1

9

2752

Optimizer Memory (KB)|SQLServer:Memory Manager|

1744

191016

28980.800

5

15

2360

@@cpu_busy

80

43806

15228.917

39

97

8416

Log Pool Memory (KB)|SQLServer:Memory Manager|

8416

21816

8639.333

49

70

1392

Connection Memory (KB)|SQLServer:Memory Manager|

1264

2816

1982.133

67

85

192

Cursor memory usage|SQLServer:Cursor Manager by Type|_Total

192

288

225.867

0

0

0

Memory Grants Outstanding|SQLServer:Memory Manager|

0

36

8.817

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

100

120

20103453

QQ=>query_optimizer elapsed time X 1000000000

13115417

20126836

16785198.033

1

9

2752

Optimizer Memory (KB)|SQLServer:Memory Manager|

1744

191016

28980.800

0

1

125

SQL Compilations/sec|SQLServer:SQL Statistics|

32

54824

15869.517

100

124

7038

QQ=>query_optimizer final cost X 1000

3837

7043

5684.200

0

1

16

SQL Re-Compilations/sec|SQLServer:SQL Statistics|

9

3765

1109.617

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

0

1

68

Query optimizations/sec|SQLServer:Workload Group Stats|internal

18

32578

9392.450

0

1

2

Suboptimal plans/sec|SQLServer:Workload Group Stats|internal

0

1293

365.417

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

63

444

17934492275

Backup/Restore Throughput/sec|SQLServer:Databases|_Total

0

28268141670

4043642476.467

0

0

1162146

Log Bytes Flushed/sec|SQLServer:Databases|_Total

462028

2030977949

329819522.933

100

100

511016768

Data File(s) Size (KB)|SQLServer:Databases|_Total

468919104

511016768

510315140.267

100

100

463074304

Data File(s) Size (KB)|SQLServer:Databases|-=Рабочая база=-

420976640

463074304

462372676.267

100

100

39774456

Log File(s) Size (KB)|SQLServer:Databases|_Total

39577976

39774456

39692589.333

4

14

1402965

Log File(s) Used Size (KB)|SQLServer:Databases|_Total

231926

33329854

10154955.383

0

1

74281

Log File(s) Used Size (KB)|SQLServer:Databases|-=Рабочая база=-

67434

32798631

9244772.083

100

104

2160952

Log File(s) Size (KB)|SQLServer:Databases|tempdb

1964472

2160952

2079085.333

66

147

1303844

Log File(s) Used Size (KB)|SQLServer:Databases|tempdb

90180

1975699

886252.917

0

1

2745

Transactions/sec|SQLServer:Databases|_Total

254

955860

205298.933

0

0

0

DBCC Logical Scan Bytes/sec|SQLServer:Databases|_Total

0

146392

20466.717

0

1

173

Write Transactions/sec|SQLServer:Databases|_Total

50

125902

25852.433

100

136

91104

Log Truncations|SQLServer:Databases|_Total

48585

91104

67144.167

0

0

33

Log Flushes/sec|SQLServer:Databases|_Total

10

40367

6612.883

0

1

16

Log Flush Waits/sec|SQLServer:Databases|_Total

4

8790

1686.267

0

0

9

Log Flush Write Time (ms)|SQLServer:Databases|_Total

4

8620

2532.017

79

123

5611

Log File(s) Used Size (KB)|SQLServer:Databases|-=технологическая база 00=-

2290

7063

4568.033

100

108

6925

Log File(s) Used Size (KB)|SQLServer:Databases|-=технологическая база 01=-

5901

6925

6413.267

41

65

695

Log File(s) Used Size (KB)|SQLServer:Databases|msdb

658

1692

1072.967

0

0

0

Log Pool Requests/sec|SQLServer:Databases|_Total

0

1023

130.367

0

0

0

Log Pool Disk Reads/sec|SQLServer:Databases|_Total

0

1000

126.000

100

102

902

Log File(s) Used Size (KB)|SQLServer:Databases|master

858

902

882.600

4

12

3

Percent Log Used|SQLServer:Databases|_Total

0

83

25.083

100

101

77

Log Growths|SQLServer:Databases|_Total

76

77

76.583

0

0

0

Active Transactions|SQLServer:Databases|_Total

0

61

15.983

52

275

16

Log Flush Wait Time|SQLServer:Databases|_Total

0

31

5.817

0

0

0

Log Pool Cache Misses/sec|SQLServer:Databases|_Total

0

6

0.933

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

1

3

171

Active Temp Tables|SQLServer:General Statistics|

27

18628

6823.433

0

1

5

Temp Tables Creation Rate|SQLServer:General Statistics|

2

1780

393.967

3

41

6

Logins/sec|SQLServer:General Statistics|

4

232

14.800

3

41

6

Logouts/sec|SQLServer:General Statistics|

4

232

14.800

34

57

29

Logical Connections|SQLServer:General Statistics|

18

86

50.950

35

57

29

User Connections|SQLServer:General Statistics|

18

84

50.783

2

7

1

Transactions|SQLServer:General Statistics|

1

52

13.850

0

0

0

SQL Trace IO Provider Lock Waits|SQLServer:General Statistics|

0

3

0.417

0

0

0

Connection Reset/sec|SQLServer:General Statistics|

0

2

0.117

0

0

0

Processes blocked|SQLServer:General Statistics|

0

2

0.467

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

2

6

4865010

Page lookups/sec|SQLServer:Buffer Manager|

99355

291864798

86848123.550

100

100

8388570

Database pages|SQLServer:Buffer Manager|

8387462

8389073

8388563.967

100

100

8388570

Database pages|SQLServer:Buffer Node|000

8387462

8389073

8388563.967

0

2

2189

Page writes/sec|SQLServer:Buffer Manager|

0

581792

122846.167

0

2

1044

Page reads/sec|SQLServer:Buffer Manager|

0

293926

51415.850

0

0

18

Readahead pages/sec|SQLServer:Buffer Manager|

0

292568

36211.017

0

0

13

Checkpoint pages/sec|SQLServer:Buffer Manager|

0

249802

54136.250

74

607

45004

_wait BACKUPBUFFER ms

0

60561

7411.391

38

231

6651

Page life expectancy|SQLServer:Buffer Manager|

285

17463

2883.233

38

231

6651

Page life expectancy|SQLServer:Buffer Node|000

285

17463

2883.233

1

3

22

Lazy writes/sec|SQLServer:Buffer Manager|

0

3267

742.350

40

188

6

Integral Controller Slope|SQLServer:Buffer Manager|

0

15

3.183

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

100

100

29969

_wait BROKER_TO_FLUSH ms

29909

30077

29998.317

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

100

100

39774456

Log File(s) Size (KB)|SQLServer:Databases|_Total

39577976

39774456

39692589.333

4

14

1402965

Log File(s) Used Size (KB)|SQLServer:Databases|_Total

231926

33329854

10154955.383

0

1

74281

Log File(s) Used Size (KB)|SQLServer:Databases|-=Рабочая база=-

67434

32798631

9244772.083

100

104

2160952

Log File(s) Size (KB)|SQLServer:Databases|tempdb

1964472

2160952

2079085.333

66

147

1303844

Log File(s) Used Size (KB)|SQLServer:Databases|tempdb

90180

1975699

886252.917

79

123

5611

Log File(s) Used Size (KB)|SQLServer:Databases|-=технологическая база 00=-

2290

7063

4568.033

100

108

6925

Log File(s) Used Size (KB)|SQLServer:Databases|-=технологическая база 01=-

5901

6925

6413.267

41

65

695

Log File(s) Used Size (KB)|SQLServer:Databases|msdb

658

1692

1072.967

100

102

902

Log File(s) Used Size (KB)|SQLServer:Databases|master

858

902

882.600

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

63

444

17934492275

Backup/Restore Throughput/sec|SQLServer:Databases|_Total

0

28268141670

4043642476.467

38

231

6651

Page life expectancy|SQLServer:Buffer Manager|

285

17463

2883.233

38

231

6651

Page life expectancy|SQLServer:Buffer Node|000

285

17463

2883.233

0

0

0

Active Transactions|SQLServer:Databases|_Total

0

61

15.983

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

63

369

17957333134

mf> num_of_bytes_read

854210

28282109952

4865214450.483

63

444

17934492275

Backup/Restore Throughput/sec|SQLServer:Databases|_Total

0

28268141670

4043642476.467

0

1

19103445

mf> num_of_bytes_written

450150

6797109901

1336210324.733

100

100

511016768

Data File(s) Size (KB)|SQLServer:Databases|_Total

468919104

511016768

510315140.267

100

100

463074304

Data File(s) Size (KB)|SQLServer:Databases|-=Рабочая база=-

420976640

463074304

462372676.267

2

6

4865010

Page lookups/sec|SQLServer:Buffer Manager|

99355

291864798

86848123.550

100

100

8388570

Database pages|SQLServer:Buffer Manager|

8387462

8389073

8388563.967

1

2

6850

_wait CXPACKET ms

516

1088079

305077.133

0

0

34

_wait SOS_SCHEDULER_YIELD ms

0

989615

220516.683

0

0

63

mf> io_stall_write_ms

15

639279

155788.433

17

44

101105

mf> io_stall_read_ms

213

591812

228864.483

8

31

29006

Lock Blocks|SQLServer:Memory Manager|

3758

354268

92677.450

0

0

45

Lock Wait Time (ms)|SQLServer:Locks|_Total

0

144322

29535.050

0

1

321

mf> num_of_writes

10

134790

44921.683

16

45

17452

mf> num_of_reads

18

107108

39176.200

38

231

6651

Page life expectancy|SQLServer:Buffer Manager|

285

17463

2883.233

38

231

6651

Page life expectancy|SQLServer:Buffer Node|000

285

17463

2883.233

100

124

7038

QQ=>query_optimizer final cost X 1000

3837

7043

5684.200

0

0

0

Longest Transaction Running Time|SQLServer:Transactions|

0

446

33.367

0

0

0

Active Transactions|SQLServer:Databases|_Total

0

61

15.983

0

0

0

Lock Waits/sec|SQLServer:Locks|_Total

0

12

1.883

Общее количество измерений, шт: 60
Ожидаемое время жизни страниц менее 1200, шт: 21 %: 35
Ожидаемое время жизни страниц менее 300 , шт: 1 %: 1

Дмитрий Горчилин РПО

-=НАЗВАНИЕ СЕРВВЕРА=- Период с 31.03.2018 19:00:00 по 01.04.2018 04:50:01
last %max last %avg Последнее значение Наименование счетчика MIN MAX AVG

0

0

0

_wait CXPACKET ms

0

100

27.667

0

0

0

_wait SOS_SCHEDULER_YIELD ms

0

100

22.100

0

0

0

Active Transactions|SQLServer:Databases|_Total

0

100

25.950

63

444

63

Backup/Restore Throughput/sec|SQLServer:Databases|_Total

0

100

14.183

100

102

100

Data File(s) Size (KB)|SQLServer:Databases|_Total

0

100

98.333

100

102

100

Data File(s) Size (KB)|SQLServer:Databases|-=Рабочая база=-

0

100

98.333

68

100

68

Database pages|SQLServer:Buffer Manager|

0

100

67.917

7

28

7

Lock Blocks|SQLServer:Memory Manager|

0

100

24.983

0

0

0

Lock Wait Time (ms)|SQLServer:Locks|_Total

0

100

20.200

0

0

0

Lock Waits/sec|SQLServer:Locks|_Total

0

100

15.550

0

0

0

Longest Transaction Running Time|SQLServer:Transactions|

0

100

7.283

17

45

17

mf> io_stall_read_ms

0

100

38.200

0

0

0

mf> io_stall_write_ms

0

100

24.067

63

375

63

mf> num_of_bytes_read

0

100

16.783

0

0

0

mf> num_of_bytes_written

0

100

19.267

16

44

16

mf> num_of_reads

0

100

36.050

0

0

0

mf> num_of_writes

0

100

32.900

37

251

37

Page life expectancy|SQLServer:Buffer Manager|

0

100

14.717

37

251

37

Page life expectancy|SQLServer:Buffer Node|000

0

100

14.717

1

3

1

Page lookups/sec|SQLServer:Buffer Manager|

0

100

29.350

99

174

99

QQ=>query_optimizer final cost X 1000

0

100

57.017