Ms 2767withh DBCC show_statistics

Hello
One of my database is quite slow. The first action i did is check
statistics, using dbccshow_statistics.
But it seems statistics are not available (SQL server returns a 2767 msg,
saying it cannot find statistics)
Thus i used update statistics on one of the table. Query analysers says the
comand is complete. But reusing dbcc update statistics shows the same error
message (2767)
The server version is
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: )
Is there any explanation ? Any ways to solve the problem ?
Thank you
XavierCan you show us:
result from
EXEC sp_helpindex 'tablename'
Your UPDATE STATISTICS command
Your DBCC SHOWSTATISTICS command
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"PetitGosaimass" <PetitGosaimass@.discussions.microsoft.com> wrote in message
news:F82C47D3-42EF-421A-A5A3-979CA887FFCD@.microsoft.com...
> Hello
> One of my database is quite slow. The first action i did is check
> statistics, using dbccshow_statistics.
> But it seems statistics are not available (SQL server returns a 2767 msg,
> saying it cannot find statistics)
> Thus i used update statistics on one of the table. Query analysers says the
> comand is complete. But reusing dbcc update statistics shows the same error
> message (2767)
> The server version is
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: )
> Is there any explanation ? Any ways to solve the problem ?
> Thank you
> Xavier
>
>|||Thank you tibor for your quick answer.
I noticed yesterday, after sending my message, that the owner of the job
maintaining the databse was unkown in the security folder of EM. I switched
to 'sa' instead of this user (that was a Nt local account).
I let the job work last night, and now i have statistics on my table.
I suppose the owner of the job had insufficient rights in the first place,
but i cannot explain why using the sa account on a query analyser yesterday,
stats wouldn't be updated.
Here are the commande i used :
as you will see, the index on this table are, hm, usiong too much columns i
think (especially reagrding density of some columns). Any advice welcome by
the way :=) .
That is why i was using the dbcc show_statistics
exec sp_helpindex 'ValeursCAR'
IX_ValeursCAR nonclustered, unique located on PRIMARY Val_Montant, Val_Zon2,
Val_Zon3, Val_Zon4, Val_RefCheque
IX_ValeursCAR_1 nonclustered located on PRIMARY Val_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_10 nonclustered located on PRIMARY Val_Lot_Nulot, Val_Dt_Trt,
Val_FlagReconc
IX_ValeursCar_11 nonclustered located on PRIMARY Val_Dt_Trt
IX_ValeursCAR_2 nonclustered located on PRIMARY Val_FlagReconc,
Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_3 nonclustered located on PRIMARY Val_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Hotesse, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_4 nonclustered located on PRIMARY Val_FlagReconc, Val_Hotesse,
Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_5 nonclustered located on PRIMARY Val_FlagReconc,
Val_Dt_Reception, Val_Hotesse, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_6 nonclustered located on PRIMARY Val_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_7 nonclustered located on PRIMARY Val_Dt_Reception,
Val_Dt_Vente, Val_Rmt_Numero, Val_Hotesse, Val_Zon8, Val_FlagReconc
IX_ValeursCAR_8 nonclustered located on PRIMARY Val_Dt_Reception,
Val_FlagReconc
IX_ValeursCAR_9 nonclustered located on PRIMARY Val_Lot_Nulot, Val_Dt_Trt
PK_ValeursCAR clustered, unique, primary key located on PRIMARY Val_Identite
DBCC SHOW_statistics (ValeursCAR,IX_ValeursCAR_2)
Does return now correct values. so i cannot send the error message ...sorry
its number was 2767
"Tibor Karaszi" wrote:
> Can you show us:
> result from
> EXEC sp_helpindex 'tablename'
> Your UPDATE STATISTICS command
> Your DBCC SHOWSTATISTICS command
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "PetitGosaimass" <PetitGosaimass@.discussions.microsoft.com> wrote in message
> news:F82C47D3-42EF-421A-A5A3-979CA887FFCD@.microsoft.com...
> > Hello
> >
> > One of my database is quite slow. The first action i did is check
> > statistics, using dbccshow_statistics.
> >
> > But it seems statistics are not available (SQL server returns a 2767 msg,
> > saying it cannot find statistics)
> > Thus i used update statistics on one of the table. Query analysers says the
> > comand is complete. But reusing dbcc update statistics shows the same error
> > message (2767)
> >
> > The server version is
> > Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> > Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows
> > NT 5.2 (Build 3790: )
> >
> > Is there any explanation ? Any ways to solve the problem ?
> >
> > Thank you
> >
> > Xavier
> >
> >
> >
> >
>