Comments
Sort by recent activity
But I like the feature [image] / comments
But I like the feature
I noticed that there are some deadlocks that spill out of the window and I can't scroll to parts. I have an "e_waitPipeNewRow" deadlock with 6 threads. The upper two process blocks are off the top of the screen. If I zoom out I can see they are there but I can read the Geeked Text. When I zoom in I can't pan up to them. [image] . / comments
I noticed that there are some deadlocks that spill out of the window and I can't scroll to parts. I have an "e_waitPipeNewRow" deadlock with 6 threads. The upper two process blocks are off the to...
I have two issues related to this topic.
First, when I use SSMS 2008R2 to connect to the Compact Edition database I am prompted for a password. I have tried my Backup Agent account password, the SQL Engine Account password, and the SQL Agent password with no luck.
What is the password for this file and where/when/how is it set?
Second, when I tried to connect with SSMS 2014/2016 I don't see a entry for Compact Edition in the Connect dialog. Is this really true?
Thanks, / comments
I have two issues related to this topic.
First, when I use SSMS 2008R2 to connect to the Compact Edition database I am prompted for a password. I have tried my Backup Agent account password, the S...
I appreciate the difference between Announcement and Topic. However, the release announcements still take up a lot of real estate. Do you really need announcements for >10 prior releases? / comments
I appreciate the difference between Announcement and Topic. However, the release announcements still take up a lot of real estate. Do you really need announcements for >10 prior releases?
Thanks / comments
Thanks
Well Duh!%#. :oops:
All I had to do was read one or two sentences farther in the documentation and I would have answered my own question (plus saved a lot of time [image] )
Thanks for the assistance. / comments
Well Duh!%#. :oops:
All I had to do was read one or two sentences farther in the documentation and I would have answered my own question (plus saved a lot of time )
Thanks for the assistance.
The errors indicate memory buffer contention for the two pages. For some reason a process has been holding the two page buffers for an extended time (e.g. > 300 seconds). A long running transaction or hung process are examples.
This article "Posts Tagged ‘A time-out occurred while waiting for buffer latch’"http://mssqlwiki.com/tag/a-time-out-occurred-while-waiting-for-buffer-latch/ is pretty detailed but has a good description of the problem and has some tips for tracing it.
Generally, you will find that there is some bottleneck that is not "obvious" until you see it. In my case the backup was trying to write 200+GB from a file group while the application(s) were inserting/updating data at a high rate. The disk just could not keep up with the I/O so memory buffers were filled with pages waiting to be written.
HTH. / comments
The errors indicate memory buffer contention for the two pages. For some reason a process has been holding the two page buffers for an extended time (e.g. > 300 seconds). A long running transaction...
I would also like to have the backup and copy in two steps.
I have a number of production jobs that I have to disable prior to starting the Full Backup. I have to do this because the disk I/O contention on the data drives was significantly slowing both production processing and backup throughput. The Full Backup was taking > 24 hours. With Jobs disabled it now takes 3 - 4 hours.
As soon as the Full Backup is completed the Production Jobs can be restarted.
The file copy to off-storage can then run without impact.
Currently I have separate Backup job steps to
Disable Selected Production Jobs
Run Backup
Enable Selected Production Jobs
Copy Backups to File Server (Power Shell) / comments
I would also like to have the backup and copy in two steps.
I have a number of production jobs that I have to disable prior to starting the Full Backup. I have to do this because the disk I/O cont...
This same issue is what prompted me to start depending on scripts and the extended stored procedure to refresh QA, Dev, and Staging environments.
It is a real pain when the GUI changes even the physical file names. / comments
This same issue is what prompted me to start depending on scripts and the extended stored procedure to refresh QA, Dev, and Staging environments.
It is a real pain when the GUI changes even the phy...
Hi Eddie,
Thanks for the guidance.
I Attached the Log Files to an email and sent them to Red Gate Support as requested.
We had a number of local security issues with the service account (<MyDomain>da_SQLDBATools) but the problems mysteriously cleared up after I asked Net Admin about them [image] So the logs will undoubtedly show a number of connection failures this morning. All of the other monitored servers are connected and responding as expected.
I also worked through the connection tests you asked about.
All of the connection tests except the WMI test worked fine. The WMI test returns the following error dialog:
Number: 0x800706b9
Facility: Win32
Description: Not enough resources are available to complete this operation
.
The target server is Windows 2008R2 Enterprise (64-bit) with 64GB RAM and 3 SQL instances (SQL 2008R2 Std, 64 bit, with SP3).
Based on following your links I concluded that memory might be the issue. I reduced the Max Server Memory for the 3 instances to 32GB, 4GB, and 4GB. Based on Perfmon, Available MBytes is now averaging 25,000 (i.e, 25GB). However, I still receive the WMI error.
FYI,
This past weekend was monthly database server maintenance and a number of things were updated (H/W and S/W).
The VM Host (Base Monitor and Web Server are on a VM) has upgraded memory.
Database servers applied Windows Updates, installed SQL2008R2 SP3, rebooted, etc.
Thanks. / comments
Hi Eddie,
Thanks for the guidance.
I Attached the Log Files to an email and sent them to Red Gate Support as requested.
We had a number of local security issues with the service account (<MyDomain>...