Database Size and SP4

As far as I know, the database size contains both Index and actual data. Is
there any command to find out the exact space occupied used by Index and
Data ? The SQL Server 2000 Database is of 5GB allocated with data (I think
it is data + Index) of 1.5GB.
Some fellow has mentioned that applying SP4 will get a better management of
memory. Is it correct ?
ThanksRobert
sp_helpdb 'pubs'
use pubs
go
sp_spaceused
"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:OChQ0CBoGHA.4628@.TK2MSFTNGP05.phx.gbl...
> As far as I know, the database size contains both Index and actual data.
> Is there any command to find out the exact space occupied used by Index
> and Data ? The SQL Server 2000 Database is of 5GB allocated with data (I
> think it is data + Index) of 1.5GB.
> Some fellow has mentioned that applying SP4 will get a better management
> of memory. Is it correct ?
> Thanks
>|||Dear Uri,
Thank you for your advice.
s there any general rule of thumb about the ratio between Index and Data ?
Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23BSW9EBoGHA.4772@.TK2MSFTNGP03.phx.gbl...
> Robert
> sp_helpdb 'pubs'
> use pubs
> go
> sp_spaceused
>
>
> "Robert" <Robert@.discussions.microsoft.com> wrote in message
> news:OChQ0CBoGHA.4628@.TK2MSFTNGP05.phx.gbl...
>> As far as I know, the database size contains both Index and actual data.
>> Is there any command to find out the exact space occupied used by Index
>> and Data ? The SQL Server 2000 Database is of 5GB allocated with data (I
>> think it is data + Index) of 1.5GB.
>> Some fellow has mentioned that applying SP4 will get a better management
>> of memory. Is it correct ?
>> Thanks
>|||Robert
Keep your indexes narrow as you can.
"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:Oln$soNoGHA.3532@.TK2MSFTNGP04.phx.gbl...
> Dear Uri,
> Thank you for your advice.
> s there any general rule of thumb about the ratio between Index and Data ?
> Thanks
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23BSW9EBoGHA.4772@.TK2MSFTNGP03.phx.gbl...
>> Robert
>> sp_helpdb 'pubs'
>> use pubs
>> go
>> sp_spaceused
>>
>>
>> "Robert" <Robert@.discussions.microsoft.com> wrote in message
>> news:OChQ0CBoGHA.4628@.TK2MSFTNGP05.phx.gbl...
>> As far as I know, the database size contains both Index and actual data.
>> Is there any command to find out the exact space occupied used by Index
>> and Data ? The SQL Server 2000 Database is of 5GB allocated with data
>> (I think it is data + Index) of 1.5GB.
>> Some fellow has mentioned that applying SP4 will get a better management
>> of memory. Is it correct ?
>> Thanks
>>
>|||Dear Uri,
Can you elaborate what does index narrow means ?
Thanking you in anticipation.
Rob
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23HGYBuNoGHA.1236@.TK2MSFTNGP03.phx.gbl...
> Robert
> Keep your indexes narrow as you can.
>
> "Robert" <Robert@.discussions.microsoft.com> wrote in message
> news:Oln$soNoGHA.3532@.TK2MSFTNGP04.phx.gbl...
>> Dear Uri,
>> Thank you for your advice.
>> s there any general rule of thumb about the ratio between Index and Data
>> ?
>> Thanks
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%23BSW9EBoGHA.4772@.TK2MSFTNGP03.phx.gbl...
>> Robert
>> sp_helpdb 'pubs'
>> use pubs
>> go
>> sp_spaceused
>>
>>
>> "Robert" <Robert@.discussions.microsoft.com> wrote in message
>> news:OChQ0CBoGHA.4628@.TK2MSFTNGP05.phx.gbl...
>> As far as I know, the database size contains both Index and actual
>> data. Is there any command to find out the exact space occupied used by
>> Index and Data ? The SQL Server 2000 Database is of 5GB allocated with
>> data (I think it is data + Index) of 1.5GB.
>> Some fellow has mentioned that applying SP4 will get a better
>> management of memory. Is it correct ?
>> Thanks
>>
>>
>|||Robert
Short, that means to create an index on columns like INT (4 bytes....) and
not on VARCHAR(8000).....
http://www.sql-server-performance.com/clustered_indexes.asp
http://www.sql-server-performance.com/nonclustered_indexes.asp
"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:Oa9cuaOoGHA.1208@.TK2MSFTNGP04.phx.gbl...
> Dear Uri,
> Can you elaborate what does index narrow means ?
> Thanking you in anticipation.
> Rob
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23HGYBuNoGHA.1236@.TK2MSFTNGP03.phx.gbl...
>> Robert
>> Keep your indexes narrow as you can.
>>
>> "Robert" <Robert@.discussions.microsoft.com> wrote in message
>> news:Oln$soNoGHA.3532@.TK2MSFTNGP04.phx.gbl...
>> Dear Uri,
>> Thank you for your advice.
>> s there any general rule of thumb about the ratio between Index and Data
>> ?
>> Thanks
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%23BSW9EBoGHA.4772@.TK2MSFTNGP03.phx.gbl...
>> Robert
>> sp_helpdb 'pubs'
>> use pubs
>> go
>> sp_spaceused
>>
>>
>> "Robert" <Robert@.discussions.microsoft.com> wrote in message
>> news:OChQ0CBoGHA.4628@.TK2MSFTNGP05.phx.gbl...
>> As far as I know, the database size contains both Index and actual
>> data. Is there any command to find out the exact space occupied used
>> by Index and Data ? The SQL Server 2000 Database is of 5GB allocated
>> with data (I think it is data + Index) of 1.5GB.
>> Some fellow has mentioned that applying SP4 will get a better
>> management of memory. Is it correct ?
>> Thanks
>>
>>
>>
>|||Thank you for your advice
Robert
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:emhSBlOoGHA.1668@.TK2MSFTNGP05.phx.gbl...
> Robert
> Short, that means to create an index on columns like INT (4 bytes....)
> and not on VARCHAR(8000).....
> http://www.sql-server-performance.com/clustered_indexes.asp
> http://www.sql-server-performance.com/nonclustered_indexes.asp
>
>
>
>
> "Robert" <Robert@.discussions.microsoft.com> wrote in message
> news:Oa9cuaOoGHA.1208@.TK2MSFTNGP04.phx.gbl...
>> Dear Uri,
>> Can you elaborate what does index narrow means ?
>> Thanking you in anticipation.
>> Rob
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%23HGYBuNoGHA.1236@.TK2MSFTNGP03.phx.gbl...
>> Robert
>> Keep your indexes narrow as you can.
>>
>> "Robert" <Robert@.discussions.microsoft.com> wrote in message
>> news:Oln$soNoGHA.3532@.TK2MSFTNGP04.phx.gbl...
>> Dear Uri,
>> Thank you for your advice.
>> s there any general rule of thumb about the ratio between Index and
>> Data ?
>> Thanks
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%23BSW9EBoGHA.4772@.TK2MSFTNGP03.phx.gbl...
>> Robert
>> sp_helpdb 'pubs'
>> use pubs
>> go
>> sp_spaceused
>>
>>
>> "Robert" <Robert@.discussions.microsoft.com> wrote in message
>> news:OChQ0CBoGHA.4628@.TK2MSFTNGP05.phx.gbl...
>> As far as I know, the database size contains both Index and actual
>> data. Is there any command to find out the exact space occupied used
>> by Index and Data ? The SQL Server 2000 Database is of 5GB allocated
>> with data (I think it is data + Index) of 1.5GB.
>> Some fellow has mentioned that applying SP4 will get a better
>> management of memory. Is it correct ?
>> Thanks
>>
>>
>>
>>
>