Welcome to the new CogKnowHow.com!


If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

Article: Content Store Size Profiling SQL Script


#1

With Cognos 8.4 there is a script,CSsize_profiling_mssqlserver2005.sql, which shows you the objects in your Content store database. In the directory C:\Program Files\COGNOS\c8\configuration\schemas\content\sqlserver you can find it. This script exist also for oracle, db2 and derby. Execute the script for MS SQL, in SOL query Analyzer for your Content Store and you will get information like below.

Total number of objects
-----------------------
1176

class name number of objects
-------------------------------------------------- -----------------
_deletedObject 13
_deletedObjectFolder 1
account 12
adminFolder 1
agentDefinition 6
agentService 1
agentTaskDefinition 10
archiveLocation 2
batchReportService 1
capability 1
configuration 1
content 1
contentManagerService 1
contentTask 1
credential 1
dataIntegrationService 1
dataSource 130
dataSourceConnection 131
dataSourceSignon 11
deliveryService 1
deploymentDetail 13
directory 1
dispatcher 1
document 2
documentContent 10
documentVersion 2
eventManagementService 1
exportDeployment 8
folder 33
group 2
history 41
historyDetail 125
historyDetailReportService 11
historyDetailRequestArguments 41
importDeployment 5
installedComponent 21
jobDefinition 1
jobService 1
jobStepDefinition 3
logService 1
memo 4
metadataService 1
metricsFileImportTask 6
metricsMaintenanceTask 21
metricsManagerService 1
model 17
modelView 17
monitorService 1
mruFolder 12
namespace 2
namespaceFolder 1
output 16
package 12
packageConfiguration 9
pageDefinition 7
pagelet 16
pageletFolder 6
periodical 1
planningApplication 1
portal 1
portalPackage 2
portalSkin 6
portalSkinFolder 1
portlet 30
portletFolder 3
portletInstance 16
portletProducer 6
presentationService 1
query 5
report 87
reportDataService 1
reportService 1
reportTemplate 57
reportVersion 4
reportView 3
role 41
root 1
runTimeState 16
schedule 2
securedFeature 28
securedFunction 22
shortcut 17
subscriptionFolder 12
systemMetricThresholds 4
systemService 1
transientStateFolder 1
uiProfile 2
uiProfileFolder 2
webServiceTask 2

class name number of secured objects
-------------------------------------------------- -------------------------
_deletedObjectFolder 1
account 12
adminFolder 1
capability 1
configuration 1
content 1
directory 1
documentVersion 1
folder 3
group 2
modelView 1
namespace 2
package 11
pageDefinition 7
periodical 1
portal 1
role 25
root 1
securedFeature 22
securedFunction 22
transientStateFolder 1
uiProfile 2
uiProfileFolder 1

Total number of outputs Total size of outputs
----------------------- ---------------------
26 709396

Outputs under 10KB
------------------
10

Outputs 10KB - 100KB
--------------------
14

Outputs 100KB - 1MB
-------------------
2

Outputs 1MB - 10MB
------------------
0

Outputs 10MB-100MB
------------------
0

Outputs 100MB-1GB
-----------------
0

Outputs > 1GB
-------------
0

class name Total number of specifications Total size of specifications
-------------------------------------------------- ------------------------------ ----------------------------
query 5 11968
report 87 8950792
reportTemplate 57 8428154
reportVersion 4 142124

Specifications < 10KB
---------------------
12

Specifications 10KB - 100KB
---------------------------
82

Specifications 100KB - 1MB
--------------------------
59

Specifications > 1MB
--------------------
0

class name Total number of specifications Total size of specifications
-------------------------------------------------- ------------------------------ ----------------------------

class name Total number of specifications Total size of specifications
-------------------------------------------------- ------------------------------ ----------------------------

class name Total number of specifications Total size of specifications
-------------------------------------------------- ------------------------------ ----------------------------

class name Total number of specifications Total size of specifications
-------------------------------------------------- ------------------------------ ----------------------------

class name Total number of specifications Total size of specifications
-------------------------------------------------- ------------------------------ ----------------------------

class name Total number of specifications Total size of specifications
-------------------------------------------------- ------------------------------ ----------------------------

class name Total number of specifications Total size of specifications
-------------------------------------------------- ------------------------------ ----------------------------

class name Total number of specifications Total size of specifications
-------------------------------------------------- ------------------------------ ----------------------------

class name Total number of specifications Total size of specifications
-------------------------------------------------- ------------------------------ ----------------------------

Total number of models
----------------------
17

Models < 10KB
-------------
5

Models 10KB - 100KB
-------------------
4

Models 100KB - 1MB
------------------
8

Models > 1MB
------------
0

object class number of children number of objects
-------------------------------------------------- -------------------- -----------------
dataSource 1 129
dataSource 2 1
dataSourceConnection 1 11
folder 1 3
folder 2 4
folder 3 5
folder 5 1
folder 7 1
folder 9 3
folder 10 3
folder 17 3
reportVersion 1 1
reportVersion 2 1
reportVersion 4 1
reportVersion 9 1

schedule type number of schedules
------------- -------------------
4 2

object class number of children number of objects
-------------------------------------------------- -------------------- -----------------
dataSource 1 129
dataSource 2 1
dataSourceConnection 1 11
folder 1 3
folder 2 4
folder 3 5
folder 5 1
folder 7 1
folder 9 3
folder 10 3
folder 17 3
jobDefinition 3 1
query 1 1
report 1 2
reportVersion 1 1
reportVersion 2 1
reportVersion 4 1
reportVersion 9 1
reportView 1 1

Number of empty policies
------------------------
0

Policies 1-127 bytes
--------------------
20

Policies 128-255 bytes
----------------------
61

Policies 256-511 bytes
----------------------
36

Policies 512-1023 bytes
-----------------------
4

Policies 1K-2K
--------------
0

Policies 2K-4K
--------------
0

Policies 4K-6K
--------------
0

Policies 6K-8K
--------------
0

Policies > 8K
-------------
0

 

www.cogknowhow.com