I have setup a pull transactional replications which replicates every 24 hrs.
Tables I am replicating has heavy transaction activity, like we make atleast
100 thousand transactions on those tables.
When distributor agnt tries to run on schedule every day morning at 2:00 am
, it just keeps on running thru out the day...is there option i can check so
that it replicates faster..?
have a look at replicating the execution of stored procedures.
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
"SQL Replication Guy" <SQLReplicationGuy@.discussions.microsoft.com> wrote in
message news:F7C0361D-3B8D-4D06-AB03-A214BA8F7217@.microsoft.com...
> I have setup a pull transactional replications which replicates every 24
hrs.
> Tables I am replicating has heavy transaction activity, like we make
atleast
> 100 thousand transactions on those tables.
> When distributor agnt tries to run on schedule every day morning at 2:00
am
> , it just keeps on running thru out the day...is there option i can check
so
> that it replicates faster..?
Showing posts with label activity. Show all posts
Showing posts with label activity. Show all posts
Thursday, March 8, 2012
Friday, February 24, 2012
2005 selected databas monitoring - how?
I have three databases with same user login. How can I monitor activity only
for one database (logins, transactions) in SQL 2005 server?
I can't change the user for this database.
Hi
You can filter the database by db_id within sql server profiler
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I have three databases with same user login. How can I monitor activity
>only for one database (logins, transactions) in SQL 2005 server?
> I can't change the user for this database.
>
|||Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that it
was in 2000 profiler, but it's like here is some changes in 2005.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
> Hi
> You can filter the database by db_id within sql server profiler
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>
|||No, just check all events and all columns and you will see
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
> Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that
> it was in 2000 profiler, but it's like here is some changes in 2005.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>
|||Thank You. I found it.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:urV6K7WZHHA.4396@.TK2MSFTNGP06.phx.gbl...
> No, just check all events and all columns and you will see
>
>
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
>
for one database (logins, transactions) in SQL 2005 server?
I can't change the user for this database.
Hi
You can filter the database by db_id within sql server profiler
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I have three databases with same user login. How can I monitor activity
>only for one database (logins, transactions) in SQL 2005 server?
> I can't change the user for this database.
>
|||Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that it
was in 2000 profiler, but it's like here is some changes in 2005.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
> Hi
> You can filter the database by db_id within sql server profiler
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>
|||No, just check all events and all columns and you will see
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
> Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that
> it was in 2000 profiler, but it's like here is some changes in 2005.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>
|||Thank You. I found it.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:urV6K7WZHHA.4396@.TK2MSFTNGP06.phx.gbl...
> No, just check all events and all columns and you will see
>
>
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
>
2005 selected databas monitoring - how?
I have three databases with same user login. How can I monitor activity only
for one database (logins, transactions) in SQL 2005 server?
I can't change the user for this database.Hi
You can filter the database by db_id within sql server profiler
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I have three databases with same user login. How can I monitor activity
>only for one database (logins, transactions) in SQL 2005 server?
> I can't change the user for this database.
>|||Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that it
was in 2000 profiler, but it's like here is some changes in 2005.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
> Hi
> You can filter the database by db_id within sql server profiler
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>>I have three databases with same user login. How can I monitor activity
>>only for one database (logins, transactions) in SQL 2005 server?
>> I can't change the user for this database.
>|||No, just check all events and all columns and you will see
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
> Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that
> it was in 2000 profiler, but it's like here is some changes in 2005.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>> Hi
>> You can filter the database by db_id within sql server profiler
>>
>> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
>> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>>I have three databases with same user login. How can I monitor activity
>>only for one database (logins, transactions) in SQL 2005 server?
>> I can't change the user for this database.
>>
>|||Thank You. I found it.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:urV6K7WZHHA.4396@.TK2MSFTNGP06.phx.gbl...
> No, just check all events and all columns and you will see
>
>
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
>> Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that
>> it was in 2000 profiler, but it's like here is some changes in 2005.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>> Hi
>> You can filter the database by db_id within sql server profiler
>>
>> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
>> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>>I have three databases with same user login. How can I monitor activity
>>only for one database (logins, transactions) in SQL 2005 server?
>> I can't change the user for this database.
>>
>>
>
for one database (logins, transactions) in SQL 2005 server?
I can't change the user for this database.Hi
You can filter the database by db_id within sql server profiler
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I have three databases with same user login. How can I monitor activity
>only for one database (logins, transactions) in SQL 2005 server?
> I can't change the user for this database.
>|||Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that it
was in 2000 profiler, but it's like here is some changes in 2005.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
> Hi
> You can filter the database by db_id within sql server profiler
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>>I have three databases with same user login. How can I monitor activity
>>only for one database (logins, transactions) in SQL 2005 server?
>> I can't change the user for this database.
>|||No, just check all events and all columns and you will see
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
> Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that
> it was in 2000 profiler, but it's like here is some changes in 2005.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>> Hi
>> You can filter the database by db_id within sql server profiler
>>
>> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
>> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>>I have three databases with same user login. How can I monitor activity
>>only for one database (logins, transactions) in SQL 2005 server?
>> I can't change the user for this database.
>>
>|||Thank You. I found it.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:urV6K7WZHHA.4396@.TK2MSFTNGP06.phx.gbl...
> No, just check all events and all columns and you will see
>
>
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
>> Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that
>> it was in 2000 profiler, but it's like here is some changes in 2005.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>> Hi
>> You can filter the database by db_id within sql server profiler
>>
>> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
>> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>>I have three databases with same user login. How can I monitor activity
>>only for one database (logins, transactions) in SQL 2005 server?
>> I can't change the user for this database.
>>
>>
>
2005 selected databas monitoring - how?
I have three databases with same user login. How can I monitor activity only
for one database (logins, transactions) in SQL 2005 server?
I can't change the user for this database.
Hi
You can filter the database by db_id within sql server profiler
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I have three databases with same user login. How can I monitor activity
>only for one database (logins, transactions) in SQL 2005 server?
> I can't change the user for this database.
>
|||Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that it
was in 2000 profiler, but it's like here is some changes in 2005.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
> Hi
> You can filter the database by db_id within sql server profiler
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>
|||No, just check all events and all columns and you will see
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
> Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that
> it was in 2000 profiler, but it's like here is some changes in 2005.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>
|||Thank You. I found it.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:urV6K7WZHHA.4396@.TK2MSFTNGP06.phx.gbl...
> No, just check all events and all columns and you will see
>
>
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
>
for one database (logins, transactions) in SQL 2005 server?
I can't change the user for this database.
Hi
You can filter the database by db_id within sql server profiler
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I have three databases with same user login. How can I monitor activity
>only for one database (logins, transactions) in SQL 2005 server?
> I can't change the user for this database.
>
|||Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that it
was in 2000 profiler, but it's like here is some changes in 2005.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
> Hi
> You can filter the database by db_id within sql server profiler
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>
|||No, just check all events and all columns and you will see
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
> Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that
> it was in 2000 profiler, but it's like here is some changes in 2005.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>
|||Thank You. I found it.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:urV6K7WZHHA.4396@.TK2MSFTNGP06.phx.gbl...
> No, just check all events and all columns and you will see
>
>
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
>
2005 selected databas monitoring - how?
I have three databases with same user login. How can I monitor activity only
for one database (logins, transactions) in SQL 2005 server?
I can't change the user for this database.Hi
You can filter the database by db_id within sql server profiler
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I have three databases with same user login. How can I monitor activity
>only for one database (logins, transactions) in SQL 2005 server?
> I can't change the user for this database.
>|||Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that it
was in 2000 profiler, but it's like here is some changes in 2005.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
> Hi
> You can filter the database by db_id within sql server profiler
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>|||No, just check all events and all columns and you will see
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
> Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that
> it was in 2000 profiler, but it's like here is some changes in 2005.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>|||Thank You. I found it.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:urV6K7WZHHA.4396@.TK2MSFTNGP06.phx.gbl...
> No, just check all events and all columns and you will see
>
>
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
>
for one database (logins, transactions) in SQL 2005 server?
I can't change the user for this database.Hi
You can filter the database by db_id within sql server profiler
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I have three databases with same user login. How can I monitor activity
>only for one database (logins, transactions) in SQL 2005 server?
> I can't change the user for this database.
>|||Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that it
was in 2000 profiler, but it's like here is some changes in 2005.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
> Hi
> You can filter the database by db_id within sql server profiler
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>|||No, just check all events and all columns and you will see
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
> Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that
> it was in 2000 profiler, but it's like here is some changes in 2005.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>|||Thank You. I found it.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:urV6K7WZHHA.4396@.TK2MSFTNGP06.phx.gbl...
> No, just check all events and all columns and you will see
>
>
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
>
Subscribe to:
Posts (Atom)