Mem to Leave...

Are there any tools or documentation available anywhere that describes how
one can monitor the usage/fragmentation of the mem to leave area used by SQL
Server? (SQL2K on W2K3 2 Node Cluster)One tool is VMStat. You can download it with the psslabs2004
download. You can download it from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=aec18337-887f-4ec6-a858-81f84de8082f&DisplayLang=en
-Sue
On Mon, 23 Jan 2006 12:25:02 -0800, "Cyberstorme"
<Cyberstorme@.discussions.microsoft.com> wrote:
>Are there any tools or documentation available anywhere that describes how
>one can monitor the usage/fragmentation of the mem to leave area used by SQL
>Server? (SQL2K on W2K3 2 Node Cluster)sql

Mem to Leave...

Are there any tools or documentation available anywhere that describes how
one can monitor the usage/fragmentation of the mem to leave area used by SQL
Server? (SQL2K on W2K3 2 Node Cluster)
One tool is VMStat. You can download it with the psslabs2004
download. You can download it from:
http://www.microsoft.com/downloads/d...DisplayLang=en
-Sue
On Mon, 23 Jan 2006 12:25:02 -0800, "Cyberstorme"
<Cyberstorme@.discussions.microsoft.com> wrote:

>Are there any tools or documentation available anywhere that describes how
>one can monitor the usage/fragmentation of the mem to leave area used by SQL
>Server? (SQL2K on W2K3 2 Node Cluster)

Mem to Leave...

Are there any tools or documentation available anywhere that describes how
one can monitor the usage/fragmentation of the mem to leave area used by SQL
Server? (SQL2K on W2K3 2 Node Cluster)One tool is VMStat. You can download it with the psslabs2004
download. You can download it from:
1f84de8082f&DisplayLang=en" target="_blank">http://www.microsoft.com/downloads/...&DisplayLang=en
-Sue
On Mon, 23 Jan 2006 12:25:02 -0800, "Cyberstorme"
<Cyberstorme@.discussions.microsoft.com> wrote:

>Are there any tools or documentation available anywhere that describes how
>one can monitor the usage/fragmentation of the mem to leave area used by SQ
L
>Server? (SQL2K on W2K3 2 Node Cluster)

Measuring index usage

I'm looking for a way to monitor index usage, over time, on all user tables
in a db, in order to determine which ones are getting hit the most and which
may not be getting used at all.
Any suggestions?
Thanks
--
MGMG-
Check out the article below. I think it will get you moving in the right
direction.
http://www.sqlmag.com/Article/Artic...rver_38789.html
--
Thomas
"MGeles" wrote:

> I'm looking for a way to monitor index usage, over time, on all user table
s
> in a db, in order to determine which ones are getting hit the most and whi
ch
> may not be getting used at all.
> Any suggestions?
> Thanks
> --
> MG|||If you are running SQL Server 2005, you can use the new
sys.dm_db_index_operational_stats management view:
http://msdn2.microsoft.com/en-us/library/ms174281.aspx
Ryan Stonecipher
Microsoft Sql Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"MGeles" <michael.geles@.thomson.com> wrote in message
news:06668ED5-FCC7-4D62-9169-1F70E936D43B@.microsoft.com...
> I'm looking for a way to monitor index usage, over time, on all user
> tables
> in a db, in order to determine which ones are getting hit the most and
> which
> may not be getting used at all.
> Any suggestions?
> Thanks
> --
> MG|||On Thu, 27 Apr 2006 12:28:16 -0700, "Ryan Stonecipher [MSFT]"
<ryanston@.microsoft.com> wrote:

>If you are running SQL Server 2005, you can use the new
>sys.dm_db_index_operational_stats management view:
>http://msdn2.microsoft.com/en-us/library/ms174281.aspx
Ryan, that is super-kewl!!!
Now, if I could just get the shop to upgrade to Server2003, ...
Josh

Measuring index usage

I'm looking for a way to monitor index usage, over time, on all user tables
in a db, in order to determine which ones are getting hit the most and which
may not be getting used at all.
Any suggestions?
Thanks
--
MGMG-
Check out the article below. I think it will get you moving in the right
direction.
http://www.sqlmag.com/Article/ArticleID/38789/sql_server_38789.html
--
Thomas
"MGeles" wrote:
> I'm looking for a way to monitor index usage, over time, on all user tables
> in a db, in order to determine which ones are getting hit the most and which
> may not be getting used at all.
> Any suggestions?
> Thanks
> --
> MG|||If you are running SQL Server 2005, you can use the new
sys.dm_db_index_operational_stats management view:
http://msdn2.microsoft.com/en-us/library/ms174281.aspx
--
Ryan Stonecipher
Microsoft Sql Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"MGeles" <michael.geles@.thomson.com> wrote in message
news:06668ED5-FCC7-4D62-9169-1F70E936D43B@.microsoft.com...
> I'm looking for a way to monitor index usage, over time, on all user
> tables
> in a db, in order to determine which ones are getting hit the most and
> which
> may not be getting used at all.
> Any suggestions?
> Thanks
> --
> MG|||On Thu, 27 Apr 2006 12:28:16 -0700, "Ryan Stonecipher [MSFT]"
<ryanston@.microsoft.com> wrote:
>If you are running SQL Server 2005, you can use the new
>sys.dm_db_index_operational_stats management view:
>http://msdn2.microsoft.com/en-us/library/ms174281.aspx
Ryan, that is super-kewl!!!
Now, if I could just get the shop to upgrade to Server2003, ...
Josh

Measure data transfer between replicated servers

Hello All
I was wondering if there's a way to monitor/measure data-transfer
being taking place between 2 serves in a replicated environment.

I cannot see any counters, etc. to monitor this..??

thanks
SunitWhat about the SQL Server:Replication Dist counter to name but one ?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Sunit Joshi" <sjoshi@.ingr.com> wrote in message
news:8f8ffe67.0404301026.1fbedf87@.posting.google.c om...
> Hello All
> I was wondering if there's a way to monitor/measure data-transfer
> being taking place between 2 serves in a replicated environment.
> I cannot see any counters, etc. to monitor this..??
>
> thanks
> Sunit

MEANING FOR THE SYMBOL IN REPL MONITOR

Soura,
if there is a dropped connection you can see this icon.
The amount of retries is a property of the replication
agent's job, and defaults to 10 AFAIR. After that, it'll
be reported as an error.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi,
Thanks for ur reply.
I have set a test replication. In that, this symbol has been existing since
the replication has been set. But the data is replicating perfectly.
what it says?
Thanks,
Soura
"Paul Ibison" wrote:

> Soura,
> if there is a dropped connection you can see this icon.
> The amount of retries is a property of the replication
> agent's job, and defaults to 10 AFAIR. After that, it'll
> be reported as an error.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>