Viewing 15 posts - 181 through 195 (of 317 total)
After testing with uploadgenerationsperbatch set to 10 and 20, I still see table locks,
but they are shorter in duration (100-500ms as opposed to 1-5 seconds).
However I am getting 30-40%...
July 8, 2013 at 5:55 pm
I am testing reducing the value for uploadgenerationsperbatch.
I will update once I have conclusive results.
In the meantime any insights from the community would be appreciated.
Thanks,
-ap
July 3, 2013 at 9:05 am
What are the wait types on the SQL server while the server flat lines (I assume this is 100% CPU)?
Are you seeing a lot of parallel queries during these times?...
July 2, 2013 at 5:29 pm
Login B is a user in the database.
You must first drop B as a user in the database, and then you can map the login to the explicit dbo...
July 1, 2013 at 6:28 pm
As long as you have enough space for the transaction log you should be fine.
July 1, 2013 at 6:15 pm
If all of your servers are visible from the centralized server, you could do this directly via powershell and WMI calls, while looping through a list of servers.
I implemented this...
June 17, 2013 at 10:54 am
If the resource is not on line and it responds to a ping, then it is likely being used by something else.
Run nslookup and tracert for the IP. It...
June 17, 2013 at 9:35 am
What are the contents of your maintenance plan?
Does it rebuild indexes base on a fragmentation threshold.
In general I would recommend Ola Hallengren's Index and Statistics maintenance script.
It is widely considered...
June 13, 2013 at 2:43 pm
Is the P address already in use by another resource?
June 11, 2013 at 6:22 pm
NEWSEQUENTIALID() is only sequential since Windows was started.
If your EC2 server has been restarted, then the functions gets reseeded.
Also, I am not sure what the behavior is for VMs, when...
June 6, 2013 at 10:32 am
Have you checked the log of the snapshot agent (SQL Agent Job)?
June 6, 2013 at 10:24 am
Is it possible that the instance on VM2 has some kind of log on monitoring (triggers) or tracing (to a table) enabled?
May 24, 2013 at 2:55 pm
How are you connecting? Windows auth or sql auth?
Are both VMs talking to the same domain controller?
May 24, 2013 at 2:52 pm
SQL Addict (5/20/2013)
May 20, 2013 at 9:27 am
The chunk size is is just what I have grown comfortable with through experience.
Traverse the primary key if possible (else another indexed field, with a smaller chunk) in a while...
May 16, 2013 at 11:47 am
Viewing 15 posts - 181 through 195 (of 317 total)