TFS Internal Usage Statistics - 1st Half CY 2013

TFS Internal Usage Statistics - 1st Half CY 2013

Rate This
  • Comments 10

Summary

The following analysis includes the Microsoft IT internal offering for TFS and includes trends throughout the first half of 2013 (January – June 2013).  This only includes the TFS servers hosted by the IT offering.  Overall, we are continuing to have consistent growth in IT servers.  There have been efforts to clean up old projects and servers which account for some reduction in numbers.

You can see the data from the second half of 2012 here.

 

 

January 2013

June 2013

Growth

Instances

59

56

-5%

Unique Users

41,878

48,821

17%

Team Project Collections

420

500

19%

Team Projects

11,400

7,800

-32%

Work Items

19,099,619

22,759,417

19%

Source Code Files

226,492,566

234,222,381

3%

Builds Per Month

301,136

657,923

118%

Test Cases

3,905,580

4,845,580

24%

Top TFS Instances

The charts below show the top 10 IT-supported instances in several categories

“Unique Users” are the number of users that have accessed the instance in the month.  This includes any TFS operation such as reading reports with data from TFS, using TFS Web Access to view or edit work items, or viewing or checking in source code.  The sum of Unique Users for all instances is greater than the Total Unique Users in the top table and in the details table at the end of this mail.  This is because some users access more than one instance.

For full usage numbers, please see data below for June 2013.   

Thanks,
Erin

 

 

Instance

Unique
  Users

TPCs

Projects

Work
  Items

Source
  Files

Builds
  Month

Total
  Builds

Test
  Cases

1

2,371

2

44

822,969

8,017,824

39,608

788,270

228,891

2

4,573

1

3

666,006

1,811,278

181

587

46,093

3

1,109

1

4

415,408

5,957,225

8,603

116,604

94,493

4

876

24

393

762,207

10,120,450

1,474

103,078

149,114

5

1,123

29

335

486,714

7,294,033

29,768

281,830

27,548

6

2,449

24

430

650,135

5,855,657

53,669

518,821

288,486

7

901

26

274

386,100

4,993,877

832

313,806

81,479

8

2,480

24

592

558,773

6,420,331

4,214

113,032

60,276

9

548

28

130

82,644

1,669,461

985

68,239

10,544

10

572

26

155

292,291

697,727

1,845

36,888

74,967

11

626

2

33

105,099

340,837

135

5,672

19,473

12

4,347

4

104

1,847,043

37,103,166

232,207

981,980

1,061

13

1,015

3

220

618,245

1,576,122

4,232

136,844

308,242

14

216

16

58

65,819

659,524

1,268

52,467

23,633

15

704

18

85

25,147

336,563

365

1,640

2,080

16

1,609

44

594

565,761

10,666,641

3,688

75,637

42,009

17

1,312

27

814

347,718

7,916,676

2,707

64,069

48,894

18

1,597

31

292

342,073

2,329,674

7,097

86,538

93,382

19

11

2

65

250

327

0

0

0

20

665

16

59

103,785

3,253,543

4,823

59,234

3,389

21

231

3

20

13,457

2,713,013

0

62

5

22

112

1

106

1,202,663

2,127,971

0

0

0

23

797

36

211

138,816

195,327

222

1,345

29,660

24

699

4

57

164,102

477,878

70

17,805

8,117

25

633

2

48

139,269

1,768,126

2,769

20,942

32,139

26

38

2

2

1,999

11

0

0

1,450

27

204

3

60

38,161

353,319

903

9,717

8,749

28

84

1

59

137,939

797,836

35

28,477,204

65,932

29

76

1

2

219,443

5,814,507

0

0

0

30

1,452

3

58

348,524

7,789,773

11,088

461,566

33,522

31

114

1

31

46,534

723,012

1,166

272,116

9,895

32

2,014

5

23

515,140

144,627

780

21,721

309,782

33

296

11

360

254,160

3,433,560

180

95,400

27,410

34

495

7

19

480,917

32,182

6

129

1,575

35

104

3

122

369,923

6,943,754

11

82,023

128,506

36

39

1

7

1,585

17,893

0

0

136

37

3,311

11

425

1,770,062

15,890,927

16,145

1,161,175

702,019

38

2,901

5

489

1,335,418

12,334,804

7,225

429,141

538,706

39

1,133

6

239

482,130

25,610,695

2,265

428,671

163,119

40

1,483

4

176

667,546

7,844,662

12,341

552,753

136,216

41

98

6

51

2,375

251,023

287

4,152

5

42

271

3

20

394,182

537,790

1,363

960,237

282,186

43

565

4

38

913,117

750,268

34

5,822

11,289

44

34

1

14

36,501

12,041

0

19

0

45

519

1

5

220,161

2,498,984

16,103

1,544,989

35,386

46

351

2

26

29,404

2,523,150

1,300

11,478

227

47

319

1

3

69,730

207,318

3,251

36,302

4,263

48

40

2

5

2,803

28,172

0

0

198

49

309

12

305

59,051

2,283,897

632

15,859

4,591

50

2,862

1

24

1,300,350

4,486,878

111,185

169,843

58,132

51

231

1

7

1,318

55

0

0

0

52

83

2

24

20,042

852,687

0

79,255

1,307

53

1,069

1

36

122,811

349,333

974

30,348

5,898

54

2,707

2

10

959,686

18,466

0

1

14,908

55

1,365

2

13

110,444

1,388,937

10,084

43,389

8,587

56

3,200

1

21

1,045,467

5,998,569

59,803

1,873,221

617,611

Leave a Comment
  • Please add 8 and 3 and type the answer here:
  • Post
  • Are these reports created using SSRS or directly querying from warehouse??

    Any sample reports pack which can be used by everyone on this?

  • @MB, we get this information by directly querying the operational databases.  Here are the queries we use.  Please note that since this is off the operational databases, we don't guarantee that the schemas will stay the same in future releases.

    -- TFS 2010 and TFS 2012

    Select count (distinct [ID]) as TheCount from WorkitemsAre with (nolock) -- count of workitems

    select  count (*) as TheCount from tbl_Projects with (nolock) where state='WellFormed' -- count of projects

    select count(distinct IdentityName) as TheCount from tbl_Command (nolock) -- count of active users over the past two weeks

    Select isnull (max (BuildId), 0) as TheCount from tbl_build with (nolock)  -- count of total builds

    select sum(size/128) as TheCount from sysfiles with (nolock) -- size of TPC DB

    select  count(distinct [ID]) as TheCount from WorkitemsAre with (nolock) WHERE [Work Item Type] = 'Test Case' -- count of test cases

    SELECT  sum ( a.used_page_count ) * 8 /1024 AS TheCount FROM sys.dm_db_partition_stats a with (nolock) join sys.objects b with (nolock) on a.object_id = b.object_id WHERE b.name = 'attachments' and (index_id=0 OR index_id=1)GROUP BY a.object_id   -- size of workitem attachments

    select SUM(UncompressedLength)/1024/1024 as TheCount from dbo.tbl_Attachment with (nolock)   -- size of test case attachments

    select COUNT(c.name)as TheCount from sys.columns c join sys.tables t on c.object_id=t.object_id where t.name='WorkItemslatest'  -- count of workitem fields

    select COUNT (*) as TheCount from Fields where ReportingType<>0 and fdeleted=0  -- count of reportable fields

    -- TFS 2010          

    select  count (FileId) as TheCount from tbl_file with (nolock)  -- count of source files  

    SELECT count(*) as TheCount FROM attachments with (nolock)    -- count of work item attachments

    SELECT count( distinct attachmentid ) AS TheCount FROM tbl_attachment with (nolock)  -- count of test case attachments

    -- TFS 2012

    select count(distinct fileid) as TheCount from tbl_file (nolock) where ownerid=1 and deletedon is null  -- count of source files

    select count(distinct fileid) as TheCount from tbl_file (nolock) where ownerid=2 and deletedon is null  -- count of WIT attachments

    select count(distinct fileid) as TheCount from tbl_file (nolock) where ownerid=4 and deletedon is null  -- count of test case attachments

  • Any count on the # of Visual SourceSafe instances left inside corp? :)

  • @ColinBowern, there are none that I know of :)  Doesn't mean someone doesn't have one under their desk...

  • Why was there such explosive growth in builds??!?! Builds Per Month - 118%

  • Would be great if you included the number of TFS Lab Management VMs, Test Plans, and Test suites in these numbers.

  • Also, why is DevDiv still not using Test Cases and MTM? Any explanation when DevDiv will finally dogfood their own product and move off Quality Center?

  • @John Schmouth,

    Thanks for the feedback, I'll see if those numbers can be added to the report.

    As for DevDiv using Test Cases and MTM, it is in the works.  We have a dogfood server where about 500 people already use it.  Since we host the dogfood server, and not IT, the numbers for that server aren't included here.  The rest of DevDiv uses an internal tool and we are working on a plan to move to our shipping product.

  • Who are the MSIT# and the consolidated(#) groups?

  • Any plans on providing stats for 2014?

Page 1 of 1 (10 items)