Viewing 15 posts - 226 through 240 (of 391 total)
Hi,
have you "cleaned" your plancache, and your statistics?
Have you checked your waits during / after the test?
What about the execution plans from your queries?
Have you...
June 8, 2018 at 7:00 am
Hm,
I think this should be 20% and 500 Row.
Not 500 Rows + 20%
And than, your 50k records won't auto update your statistic.
Take a lock at...
June 4, 2018 at 12:00 am
Hi,
have you checked your windows performance counter for the network interface card (nic)
If there was some kind of error, you should see something in the counters.
Kind regards,
May 18, 2018 at 7:07 am
It there no admin online to block this fu... account: "rtgfbhsrtjfr3"
He is posting spam a few seconds ago.
Best regards,
Andreas
May 18, 2018 at 12:38 am
May 18, 2018 at 12:03 am
Hi,
you can use an udl file:
https://blogs.msdn.microsoft.com/farukcelik/2007/12/31/basics-first-udl-test/
It is quite simple to use
best regards,
Andreas
May 14, 2018 at 5:56 am
Hi,
if you use standard edition:
Standard | Limited to lesser of 4 Sockets or 16... |
May 4, 2018 at 5:57 am
Hi,
use min max memory settings to use much ram as possible. But let some ram for the os , I think you shold set the max memory to ...
May 4, 2018 at 5:38 am
Hi,
please show us the ERRORLOG from the sql server.
Sometimes VEEAM snapshots create some frozen messages in the SQL ERRORLOG.
Maybe this could be the rout cause of your...
May 2, 2018 at 12:31 am
Hi,
please post your t-sql code you create until now.
And show us the create script of the tables you use.
With this kind of discription, no one could...
April 26, 2018 at 1:03 am
I have not made any changes to indexing on the subscriber/distributor - I only add/remove/maintain indexes on the publisher
Hm,
but if you rebuild an index, the new...
April 24, 2018 at 1:42 am
One publisher server, 27 publications, One distribution database.
I think you could be right , because...
April 23, 2018 at 11:57 pm
Hi,
how many publisher (Server) do you use, and how many distribution databases do you have?
If you only got 1 distribution database, then there maybe a lot of blockings....
April 23, 2018 at 6:39 am
Hi,
you can delete data / rows at the subscriber,
BUT,
if you had to create a new snapshot, maybe for some new article or transactional replication ist broken, all...
April 23, 2018 at 6:36 am
Hi,
do you use single windows logins, or windows group logins on the sql server?
Best regards,
Andreas
April 18, 2018 at 1:51 am
Viewing 15 posts - 226 through 240 (of 391 total)