sql2005 standard edition
In replication monitor, under Publication tab, the Current Average
Performance and Current Worst Performance show "Poor" for one publication,
and this has been like this for a few days.
The publisher server is not under heavy load at all. In Perfmon I checked
Delivery Latency and Delivered Trans.sec for the related replication jobs and
all show 0.
Could anybody tell me what else I need to look into and where to start with
troubleshooting? I am new to replication. Thanks a lot.
Claudia
Look on the subscriber to see if there are user triggers on this or
different indexes. Also is the subscriber the same hardware and
configuration as the other subscribers? Are there any other processes
running on this machine?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Claudia" <Claudia@.discussions.microsoft.com> wrote in message
news:1292940D-2268-4C27-ADED-5206FC3CF225@.microsoft.com...
> sql2005 standard edition
> In replication monitor, under Publication tab, the Current Average
> Performance and Current Worst Performance show "Poor" for one publication,
> and this has been like this for a few days.
> The publisher server is not under heavy load at all. In Perfmon I checked
> Delivery Latency and Delivered Trans.sec for the related replication jobs
> and
> all show 0.
> Could anybody tell me what else I need to look into and where to start
> with
> troubleshooting? I am new to replication. Thanks a lot.
> Claudia
>
|||The subscriber hardware is the same. No triggers on subscriber. The tables
involved in replication are all small tables (18 tables, the biggest one has
600 records, and the rest of tables have < 100 records). There're a few
connections to the subscriber DB but they are in sleeping mode. The only
connections with Open Transaction showing 1 are from the replication, which
seems normal.
The articles
"Hilary Cotter" wrote:
> Look on the subscriber to see if there are user triggers on this or
> different indexes. Also is the subscriber the same hardware and
> configuration as the other subscribers? Are there any other processes
> running on this machine?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Claudia" <Claudia@.discussions.microsoft.com> wrote in message
> news:1292940D-2268-4C27-ADED-5206FC3CF225@.microsoft.com...
>
>
|||Have you updated the indexes?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Claudia" <Claudia@.discussions.microsoft.com> wrote in message
news:7D92F872-3FFE-4AF6-B367-D58CD60C85E2@.microsoft.com...[vbcol=seagreen]
> The subscriber hardware is the same. No triggers on subscriber. The tables
> involved in replication are all small tables (18 tables, the biggest one
> has
> 600 records, and the rest of tables have < 100 records). There're a few
> connections to the subscriber DB but they are in sleeping mode. The only
> connections with Open Transaction showing 1 are from the replication,
> which
> seems normal.
>
> The articles
> "Hilary Cotter" wrote:
Showing posts with label current. Show all posts
Showing posts with label current. Show all posts
Wednesday, March 28, 2012
poor performance of publication
Labels:
averageperformance,
current,
database,
editionin,
microsoft,
monitor,
mysql,
oracle,
performance,
poor,
publication,
replication,
server,
sql,
sql2005,
standard,
tab,
worst
Tuesday, March 20, 2012
plus/minus icon
hi,
the plus/minus icon is showing the inverse of the current state of the group
i.e. if the group is open (meaning that the sub rows are visible) the icon
shows as plus instead of minus, and vice versa.
my report is defaulting to the hidden=false option, and probably this is
why. So how can i have my report default to a full view and have the
plus/minus icon show correctly? or is this a bug or something?This can be a little tricky to get set up.
Take a look at the Visibility tab on the Advanced Textbox Properties dialog.
It has a option to control the initial appearance of the toggle item.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Emmanuel" <emmanuel@.email.com> wrote in message
news:OXGYewIpEHA.2784@.TK2MSFTNGP14.phx.gbl...
> hi,
> the plus/minus icon is showing the inverse of the current state of the
group
> i.e. if the group is open (meaning that the sub rows are visible) the icon
> shows as plus instead of minus, and vice versa.
> my report is defaulting to the hidden=false option, and probably this is
> why. So how can i have my report default to a full view and have the
> plus/minus icon show correctly? or is this a bug or something?
>
the plus/minus icon is showing the inverse of the current state of the group
i.e. if the group is open (meaning that the sub rows are visible) the icon
shows as plus instead of minus, and vice versa.
my report is defaulting to the hidden=false option, and probably this is
why. So how can i have my report default to a full view and have the
plus/minus icon show correctly? or is this a bug or something?This can be a little tricky to get set up.
Take a look at the Visibility tab on the Advanced Textbox Properties dialog.
It has a option to control the initial appearance of the toggle item.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Emmanuel" <emmanuel@.email.com> wrote in message
news:OXGYewIpEHA.2784@.TK2MSFTNGP14.phx.gbl...
> hi,
> the plus/minus icon is showing the inverse of the current state of the
group
> i.e. if the group is open (meaning that the sub rows are visible) the icon
> shows as plus instead of minus, and vice versa.
> my report is defaulting to the hidden=false option, and probably this is
> why. So how can i have my report default to a full view and have the
> plus/minus icon show correctly? or is this a bug or something?
>
Monday, March 12, 2012
Pls Help - Urgent handling "-" in query
Hi,
i am using sp_addlinkedserver to connect with my another server.
Let say my current server name is anand and other server name is anand-new
now sp_addlinkedserver worked ok
Now i want to fetch some record from the anand-new server.
I am writing my query in I server (i.e. Anand)
SELECT TOP 10 * FROM anand-new.NEWSITE.DBO.Xyz_NEW
I am getting error
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '-'.
Pls help
Its urgent
Cheers,
AnandSELECT TOP 10 * FROM [anand-new.NEWSITE.DBO.Xyz_NEW]|||Sounds like you (or your DBA) should avoid using such characters in server names! I hate seeing SQL that is full of square brackets!
i am using sp_addlinkedserver to connect with my another server.
Let say my current server name is anand and other server name is anand-new
now sp_addlinkedserver worked ok
Now i want to fetch some record from the anand-new server.
I am writing my query in I server (i.e. Anand)
SELECT TOP 10 * FROM anand-new.NEWSITE.DBO.Xyz_NEW
I am getting error
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '-'.
Pls help
Its urgent
Cheers,
AnandSELECT TOP 10 * FROM [anand-new.NEWSITE.DBO.Xyz_NEW]|||Sounds like you (or your DBA) should avoid using such characters in server names! I hate seeing SQL that is full of square brackets!
Subscribe to:
Posts (Atom)