Explain

Counter Name: SQL Server General Statistics: User Connections
This shows the number of user connections, not the number of users that
currently are connected to SQL Server. Since the number of users using SQL
Server affects its performance, you may want to keep an eye on this counter.
Can any one let me know the difference between user connections and not the
number of users that currently are connected to SQL Server.
This shows the number of user connections, not the number of users that
currently are connected to SQL Server. Since the number of users using SQL
Server affects its performance, you may want to keep an eye on this counter.
"Rogers" wrote:

> Counter Name: SQL Server General Statistics: User Connections
> This shows the number of user connections, not the number of users that
> currently are connected to SQL Server. Since the number of users using SQL
> Server affects its performance, you may want to keep an eye on this counter.
>
|||In SQL 2000 any SPIDs below 50 are system connections. These are connections
that SQL Server uses to manage the server. Any SPID over 50 is a user
connection but may include things like SQL Agent, DTS etc. The description
below is not the best in my opinion but what it is trying to say is that you
can have a single user (person or application) that may have more than one
connection.
Andrew J. Kelly SQL MVP
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:7C5C92E7-84FF-404F-987E-86A2BA6832B6@.microsoft.com...[vbcol=seagreen]
> Can any one let me know the difference between user connections and not
> the
> number of users that currently are connected to SQL Server.
> This shows the number of user connections, not the number of users that
> currently are connected to SQL Server. Since the number of users using SQL
> Server affects its performance, you may want to keep an eye on this
> counter.
>
> "Rogers" wrote:
|||What I want to ask like in the sp_configure there is user connection, is that
means how many users can connected simultaneously?
"Andrew J. Kelly" wrote:

> In SQL 2000 any SPIDs below 50 are system connections. These are connections
> that SQL Server uses to manage the server. Any SPID over 50 is a user
> connection but may include things like SQL Agent, DTS etc. The description
> below is not the best in my opinion but what it is trying to say is that you
> can have a single user (person or application) that may have more than one
> connection.
> --
> Andrew J. Kelly SQL MVP
>
> "Rogers" <Rogers@.discussions.microsoft.com> wrote in message
> news:7C5C92E7-84FF-404F-987E-86A2BA6832B6@.microsoft.com...
>
>
|||> What I want to ask like in the sp_configure there is user connection, is
that
> means how many users can connected simultaneously?
The Perfmon counter shows the number of users connected to the system. Use
the sp_configure user connections option to specify the maximum number of
simultaneous user connections allowed on SQL Server.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

Execution plan says statistics are missing but they do exist

I am looking at the graphical estimated execution plan in Query
Analyzer for a query. One of the steps in the query is in red and
indicates "Warning: Statistics missing for this table..." for a column.
However I have used both sp_helpstats and DBCC SHOW_STATISTICS to
verify that statistics do in fact exist for this column. Is this just a
Query Analyzer bug or is this something to worry about where the
optimizer is not seeing statistics that do in fact exist?
ThanksThe stats might be out of date, so you might want to run 'update statistics
with fullscan'.
-oj
<pshroads@.gmail.com> wrote in message
news:1139267489.347659.231960@.g43g2000cwa.googlegroups.com...
>I am looking at the graphical estimated execution plan in Query
> Analyzer for a query. One of the steps in the query is in red and
> indicates "Warning: Statistics missing for this table..." for a column.
> However I have used both sp_helpstats and DBCC SHOW_STATISTICS to
> verify that statistics do in fact exist for this column. Is this just a
> Query Analyzer bug or is this something to worry about where the
> optimizer is not seeing statistics that do in fact exist?
> Thanks
>|||Hi thanks for responding.
I have already tried an update stats with full scan. The execution plan
still says that there are statistics missing.|||Hmm...Does it give you the name of the stat? If so, drop and recreate it.
If that still doesn't work, consider rebuilding your clustered index.
-oj
<pshroads@.gmail.com> wrote in message
news:1139331944.099545.38580@.g44g2000cwa.googlegroups.com...
> Hi thanks for responding.
> I have already tried an update stats with full scan. The execution plan
> still says that there are statistics missing.
>

Execution plan says statistics are missing but they do exist

I am looking at the graphical estimated execution plan in Query
Analyzer for a query. One of the steps in the query is in red and
indicates "Warning: Statistics missing for this table..." for a column.
However I have used both sp_helpstats and DBCC SHOW_STATISTICS to
verify that statistics do in fact exist for this column. Is this just a
Query Analyzer bug or is this something to worry about where the
optimizer is not seeing statistics that do in fact exist?
Thanks
The stats might be out of date, so you might want to run 'update statistics
with fullscan'.
-oj
<pshroads@.gmail.com> wrote in message
news:1139267489.347659.231960@.g43g2000cwa.googlegr oups.com...
>I am looking at the graphical estimated execution plan in Query
> Analyzer for a query. One of the steps in the query is in red and
> indicates "Warning: Statistics missing for this table..." for a column.
> However I have used both sp_helpstats and DBCC SHOW_STATISTICS to
> verify that statistics do in fact exist for this column. Is this just a
> Query Analyzer bug or is this something to worry about where the
> optimizer is not seeing statistics that do in fact exist?
> Thanks
>
|||Hi thanks for responding.
I have already tried an update stats with full scan. The execution plan
still says that there are statistics missing.
|||Hmm...Does it give you the name of the stat? If so, drop and recreate it.
If that still doesn't work, consider rebuilding your clustered index.
-oj
<pshroads@.gmail.com> wrote in message
news:1139331944.099545.38580@.g44g2000cwa.googlegro ups.com...
> Hi thanks for responding.
> I have already tried an update stats with full scan. The execution plan
> still says that there are statistics missing.
>

Execution plan says statistics are missing but they do exist

I am looking at the graphical estimated execution plan in Query
Analyzer for a query. One of the steps in the query is in red and
indicates "Warning: Statistics missing for this table..." for a column.
However I have used both sp_helpstats and DBCC SHOW_STATISTICS to
verify that statistics do in fact exist for this column. Is this just a
Query Analyzer bug or is this something to worry about where the
optimizer is not seeing statistics that do in fact exist?
ThanksThe stats might be out of date, so you might want to run 'update statistics
with fullscan'.
--
-oj
<pshroads@.gmail.com> wrote in message
news:1139267489.347659.231960@.g43g2000cwa.googlegroups.com...
>I am looking at the graphical estimated execution plan in Query
> Analyzer for a query. One of the steps in the query is in red and
> indicates "Warning: Statistics missing for this table..." for a column.
> However I have used both sp_helpstats and DBCC SHOW_STATISTICS to
> verify that statistics do in fact exist for this column. Is this just a
> Query Analyzer bug or is this something to worry about where the
> optimizer is not seeing statistics that do in fact exist?
> Thanks
>|||Hi thanks for responding.
I have already tried an update stats with full scan. The execution plan
still says that there are statistics missing.|||Hmm...Does it give you the name of the stat? If so, drop and recreate it.
If that still doesn't work, consider rebuilding your clustered index.
--
-oj
<pshroads@.gmail.com> wrote in message
news:1139331944.099545.38580@.g44g2000cwa.googlegroups.com...
> Hi thanks for responding.
> I have already tried an update stats with full scan. The execution plan
> still says that there are statistics missing.
>

Execution plan says statistics are missing but they do exist

I am looking at the graphical estimated execution plan in Query
Analyzer for a query. One of the steps in the query is in red and
indicates "Warning: Statistics missing for this table..." for a column.
However I have used both sp_helpstats and DBCC SHOW_STATISTICS to
verify that statistics do in fact exist for this column. Is this just a
Query Analyzer bug or is this something to worry about where the
optimizer is not seeing statistics that do in fact exist?
ThanksThe stats might be out of date, so you might want to run 'update statistics
with fullscan'.
-oj
<pshroads@.gmail.com> wrote in message
news:1139267489.347659.231960@.g43g2000cwa.googlegroups.com...
>I am looking at the graphical estimated execution plan in Query
> Analyzer for a query. One of the steps in the query is in red and
> indicates "Warning: Statistics missing for this table..." for a column.
> However I have used both sp_helpstats and DBCC SHOW_STATISTICS to
> verify that statistics do in fact exist for this column. Is this just a
> Query Analyzer bug or is this something to worry about where the
> optimizer is not seeing statistics that do in fact exist?
> Thanks
>|||Hi thanks for responding.
I have already tried an update stats with full scan. The execution plan
still says that there are statistics missing.|||Hmm...Does it give you the name of the stat? If so, drop and recreate it.
If that still doesn't work, consider rebuilding your clustered index.
-oj
<pshroads@.gmail.com> wrote in message
news:1139331944.099545.38580@.g44g2000cwa.googlegroups.com...
> Hi thanks for responding.
> I have already tried an update stats with full scan. The execution plan
> still says that there are statistics missing.
>

execution plan

Hi ,
The execution plan shows the estimated rows count and row
count which a big diff means the statistics is not up to
date ?
which utility will show the logical scan and extended
scan which high % means the index is fragemented ?
and also is there any help on how to interpret the results
return by the statistics ?
thks & rdgs
Hi,
Use the command DBCC SHOWCONTIG to get the fragmentation information. See
books online for command usage and details.
You could update the statistics of the table using the below command and see
the execution plan again
update statistics <table_name>
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs
|||Perhaps it would be better to update the statistics with the FULLSCAN option
if you are still getting sub-optimal plans.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs

execution plan

Hi ,
The execution plan shows the estimated rows count and row
count which a big diff means the statistics is not up to
date ?
which utility will show the logical scan and extended
scan which high % means the index is fragemented ?
and also is there any help on how to interpret the results
return by the statistics ?
thks & rdgsHi,
Use the command DBCC SHOWCONTIG to get the fragmentation information. See
books online for command usage and details.
You could update the statistics of the table using the below command and see
the execution plan again
update statistics <table_name>
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs|||>--Original Message--
>Hi ,
> The execution plan shows the estimated rows count and
row
>count which a big diff means the statistics is not up to
>date ?
> which utility will show the logical scan and extended
>scan which high % means the index is fragemented ?
>and also is there any help on how to interpret the
results
>return by the statistics ?
>thks & rdgs
>.
>|||Perhaps it would be better to update the statistics with the FULLSCAN option
if you are still getting sub-optimal plans.
--
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs

execution plan

Hi ,
The execution plan shows the estimated rows count and row
count which a big diff means the statistics is not up to
date ?
which utility will show the logical scan and extended
scan which high % means the index is fragemented ?
and also is there any help on how to interpret the results
return by the statistics ?
thks & rdgsHi,
Use the command DBCC SHOWCONTIG to get the fragmentation information. See
books online for command usage and details.
You could update the statistics of the table using the below command and see
the execution plan again
update statistics <table_name>
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs|||Perhaps it would be better to update the statistics with the FULLSCAN option
if you are still getting sub-optimal plans.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs