Number of page per table in the cache

7 Sep 2006 12:16 PM

××™×œ ×©×¤×™×¨×

Hi,

In SQL server 2000 .
Can I get list of tables and the number of page per table that
currently exist in the cache ?
Event table list without number of page will be good.

Thanks,
Eyal

7 Sep 2006 1:03 PM

Hari Prasad

Hi,

As far as I know I do not think there is command which gives you pages in
cache table wise.
There is a undocumentted DBCC PAGE command which will show the pages
database wide.
Take a look into the below URL:-
https://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/10/625659.aspx

Thanks
Hari
SQL Server MVP

Show quote

"??? ?????" <nospameyalSchapira@hotmail.com> wrote in message
news:4DBA1DB4-5F93-4084-8E9C-C14E9452E123@microsoft.com...
> Hi,
>
> In SQL server 2000 .
> Can I get list of tables and the number of page per table that
> currently exist in the cache ?
> Event table list without number of page will be good.
>
> Thanks,
> Eyal
>

7 Sep 2006 2:16 PM

××™×œ ×©×¤×™×¨×

Hi,

The URL explains the DBCC page command. Do you how can I get all the pages
in the cache (and than execute DBCC Page on each one ) ?

Thanks,
Eyal

8 Sep 2006 2:26 AM

Hari Prasad

Hi,

There is no command to get all the pages in cache.

Thanks
Hari
SQL Server MVP

Show quote

"??? ?????" <nospameyalSchapira@hotmail.com> wrote in message
news:DD9E6A9B-CD9D-40F4-B882-C22033E28EA6@microsoft.com...
> Hi,
>
> The URL explains the DBCC page command. Do you how can I get all the pages
> in the cache (and than execute DBCC Page on each one ) ?
>
>
> Thanks,
> Eyal
>