Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kshahzad
Starting Member
45 Posts |
 Posted - 2013-07-23 : 09:10:53
|
| Schema Table Index IndexType AvgFrag% AvgSpaceUsed% RecordCnt FragmentCntdbo address IX_Address_szPhone NONCLUSTERED INDEX 3 99 23200 4dbo AddressPhone PK_AddressPhone CLUSTERED INDEX 0 99 15818275 7765dbo Consultants PK_Consultants CLUSTERED INDEX 0 99 6 NULLdbo Consultants_History PK_Consultants_History CLUSTERED INDEX 0 99 9 NULLdbo CustomReport_Output_PatientPerFamilyPhysician CK_CustomReport_Output_PatientPerFamilyPhysician CLUSTERED INDEX 0 99 216680 NULLdbo Drug3_Backup_Table NULL HEAP 7 99 52399 8dbo Drugforms_Backup_Table NULL HEAP 3 99 58180 2dbo ICD_backup_ICPC NULL HEAP 0 99 88797 2dbo map_tempaltes_14July849pm NULL HEAP 35 99 858075 202dbo map_templates_12Jul13 NULL HEAP 13 99 857683 80dbo map_templates_16July1302 NULL HEAP 1 99 858157 12dbo MASTER_TemplatesDialoguesControlCheckbox NULL HEAP 0 99 189913 2dbo MASTER_TemplatesDialoguesControlSelectList NULL HEAP 1 99 46691 2dbo MASTER_TemplatesDialoguesControlSelectListListItems NULL HEAP 0 99 600884 3dbo MASTER_TemplatesDialoguesControlSelectListListName NULL HEAP 1 99 45090 2dbo MASTER_TemplatesDialoguesControlSimpleTableDefaultData NULL HEAP 0 99 548355 2dbo MASTER_TemplatesDialoguesControlStringBuilderNode NULL HEAP 2 99 68251 4dbo MASTER_TemplatesDialoguesControlTextbox NULL HEAP 0 99 91018 2dbo MASTER_TemplatesDialoguesStructure NULL HEAP 0 99 364743 2dbo MASTER_TemplatesStructure NULL HEAP 1 99 102174 2dbo NIC_Dashboard_FinancialStat_Summary PK_NIC_Dashboard_FinancialStat_Summary CLUSTERED INDEX 6 99 37875 24dbo NIC_Dashboard_OperationalStat_Summary PK_NIC_Dashboard_OperationalStat_Summary CLUSTERED INDEX 0 99 503003 180dbo NIC_Dashboard_OptionalChart_Summary PK_NIC_Dashboard_OptionalChart_Summary CLUSTERED INDEX 1 99 159886 65dbo NIC_Dashboard_PatientTrends PK_NIC_Dashboard_PatientTrends CLUSTERED INDEX 5 99 18774 12dbo PhysicianLabReportsTests PK_LabReportsTests CLUSTERED INDEX 0 99 2 NULLdbo Prescription PK_Prescription CLUSTERED INDEX 0 99 106 NULLdbo Tmp_Map_DiagnosisToProgressNote NULL HEAP 6 99 9004921 451dbo Tmp_TemplatesDialoguesStructure NULL HEAP 0 99 326785 2dbo UnmatchingPhysicianLabReportsTests IX_UnmatchingPhysicianLabReportsTests_LabReport CLUSTERED INDEX 0 99 4 NULLdbo update_inactive NULL HEAP 88 99 30856 42dbo update_route NULL HEAP 87 99 17353 16dbo Bill_NS_ServiceProviders_20111202 NULL HEAP 37 98 16693 11dbo DirectoryNB_26June2013_0957pm NULL HEAP 30 98 10068 10dbo DirectoryNS_26June2013_0928pm NULL HEAP 23 98 185635 127dbo DirectoryNS_JULY NULL HEAP 2 98 86487 8dbo DirectoryNS1 NULL HEAP 7 98 82283 19dbo DrugCompanies_Backup_Table NULL HEAP 1 98 30414 2dbo icd_bill_nb_back NULL HEAP 11 98 15227 9dbo LabForm_NSHIS PK_LabForm_NSHIS CLUSTERED INDEX 0 98 1607860 NULLdbo LOINCDB IX_LOINCDB_COMPONENT NONCLUSTERED INDEX 0 98 175 1dbo MASTER_Templates NULL HEAP 3 98 20440 2dbo MASTER_TemplatesDialogues NULL HEAP 2 98 24991 2dbo MASTER_TemplatesDialoguesControlDate NULL HEAP 10 98 9801 2dbo MASTER_TemplatesDialoguesControlSimpleTable NULL HEAP 5 98 18944 2dbo MASTER_TemplatesDialoguesControlStringBuilderNode NULL HEAP 0 98 70383 NULLdbo MASTER_TemplatesDialoguesControlTextarea NULL HEAP 1 98 36157 2dbo multum_drug_name_map NULL HEAP 23 98 80306 15dbo Report_AdHoc_Results CK_Report_AdHoc_Results CLUSTERED INDEX 0 98 212201 NULLdbo Route_Backup_Table NULL HEAP 5 98 33140 2dbo RPTResults PK_RPTResults CLUSTERED INDEX 0 98 2503755 NULLdbo TemplatesCDMOverdueAlerts PK_TemplatesCDMOverdueAlerts CLUSTERED INDEX 4 98 39094 28dbo UnmPhysicianLabReportTestPathNetHTML PK_UnmPhysicianLabReportTestPathNetHTML CLUSTERED INDEX 3 98 35673 8dbo update_comp NULL HEAP 90 98 15096 38dbo update_form NULL HEAP 85 98 15266 15dbo update_ingred3 NULL HEAP 97 98 25627 47dbo update_ther NULL HEAP 92 98 14533 26 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-07-24 : 12:15:35
|
| Generally,most of them rebuild indexes whose fragmentation level is above 30 and reorganize between 10 and 30.Ola Hallengren's script can be used for this and others too have some scripts.mohammad.javeed.ahmed@gmail.com |
 |
|
|
kshahzad
Starting Member
45 Posts |
Posted - 2013-07-24 : 16:55:18
|
| yes i am having performance issues |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Suggestions on fragmentation stats below?