Showing posts with label current. Show all posts
Showing posts with label current. Show all posts

Wednesday, March 28, 2012

poor performance of publication

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:

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?
>

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!