Can not find "this" newgroup on Outlook newsgroup...Help

Hi Seir,

I'm new to SQL and want to learn beginning SQL..

But onlye microsoft.pulic.hk.microsoftsql appear on the newsgroup in

the Outlook. So how to subscribe this news group (or the anoter for beginner)

in the Outlook for me to read it OFFLINE...

thank so much for the help.

Johan

This group is only Web based, you can configure your RSS Reader to collect the new posts.

Can I tell how often the clustered index pages are spliting?

Greetings

For performance reasons I am trying to determine how often the pages in
the index split due to inserts. Are there any records in the 'sys' tables,
etc. Thanx"Robert" <stop.spam@.boeing.com> wrote in message news:<Hsw479.Mnx@.news.boeing.com>...
> Greetings
> For performance reasons I am trying to determine how often the pages in
> the index split due to inserts. Are there any records in the 'sys' tables,
> etc. Thanx

I don't think this is stored in any system table, but you can use the
Performance Monitor counter SQLServer:AccessMethods, Page Splits/sec
to capture the information.

Simon|||Many, many thanx. I found it.

"Simon Hayes" <sql@.hayes.ch> wrote in message
news:60cd0137.0402102355.4236cb34@.posting.google.c om...
> "Robert" <stop.spam@.boeing.com> wrote in message
news:<Hsw479.Mnx@.news.boeing.com>...
> > Greetings
> > For performance reasons I am trying to determine how often the pages
in
> > the index split due to inserts. Are there any records in the 'sys'
tables,
> > etc. Thanx
> I don't think this is stored in any system table, but you can use the
> Performance Monitor counter SQLServer:AccessMethods, Page Splits/sec
> to capture the information.
> Simon