Solved

how to reduce the size of the indexes in SQL Server

Posted on 2009-06-30
4
554 Views
Last Modified: 2012-05-07
I have a database of size 100gb.When I tried to see the disk usage the size of the index is more than data size.Pls see the attached screen shot.
Iam running out of disk space and Iwant to reduce that index size.
Pls help

Thanks
inde.GIF
0
Comment
Question by:shadyc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24749847
- you can drop some unused indexes
- do an index defragmentation
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24749857
you must have created plenty of (eventually unusable) indexes.
you need to double-check each of the indexes if it is really used, and if not, drop it.

note: if the indexes graph includes the clustered indexes, those are actually containing the data of the table itself also...
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 24749999
0
 

Author Comment

by:shadyc
ID: 24750070
Thanks for helping me...I'll look in to it and get back to you
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question