Viewing 15 posts - 1 through 15 (of 284 total)
Thanks for your response. I'll try working through your suggestions. I appreciate the help.
December 21, 2020 at 8:12 pm
I would recommend that you switch over to project deployment - build out the integration services catalog - and deploy your packages to the catalog. You can then use...
December 21, 2020 at 7:46 pm
Thanks for the link, but it looks as if .ispac is a binary file and is part of the Project Deployment Model, if I am not mistaken. I would like...
December 16, 2020 at 4:48 pm
We avoid using SQL Server agent (it is unreliable in our shop, stopping on a larger server farm without warning). We use PowerShell-based Scheduled Tasks instead. Scheduled Tasks give us...
December 15, 2020 at 11:29 am
Thanks for the post. I ran across the first link before I posted here. Unless I'm missing something, neither of the links explains how the command line connects to whatever...
December 14, 2020 at 9:42 pm
I ran across http://www.kodyaz.com/articles/create-folder-sql-sys-xp_create_subdir-extended-stored-procedure.aspx and thought it might be helpful for anyone else that may find this page. The Ola Hallengren backup code uses "xp_create_subdir."
May 10, 2017 at 10:38 am
It must be our "specialized" DoD install kit. I found the files just fine on SQL Server 2016 [sic] on my microsoft.com downloaded copy of the install kit.
April 10, 2017 at 2:34 pm
Thanks for the links. You obviously knew what you were looking for. Actually, I googled quite a bit before posting on this forum, but I didn't see anything that was...
October 19, 2015 at 8:44 am
No, I haven't. Can you point me to a link?
October 18, 2015 at 12:44 pm
By the way, we think the reason that the instances would not failback to the original node *without* a reboot of the original node is that the IBM SVC software...
March 26, 2015 at 7:40 am
I think we found the issue.
A while back, I started tracking output from sys.dm_os_sys_memory over time based on code from Glenn Berry (http://www.sqlservercentral.com/blogs/glennberry/2010/08/23/dmv-emergency-queries-from-sql-saturday-_2300_51-in-nashville/).
Despite Microsoft's best efforts, the data we were...
March 26, 2015 at 6:58 am
When I googled the KB's that were installed on 02/24/2015, everyone of them came back with hits on "memory leak."
We're still looking...
March 23, 2015 at 10:43 am
Hmm.... I finally found the syntax to identify the installed patches. There were more patches installed than I thought, but the patches agree between Node B and C. It looks...
March 23, 2015 at 10:33 am
Please see the attached Excel graph of available_page_file_kb from sys.dm_os_sys_memory. We have two scheduled failovers per week to make sure that every node can be patched quickly. This explains the...
March 23, 2015 at 6:57 am
By the way, I tried using "DBCC MEMORYSTATUS," but I'm not having any luck interpreting the output. Even on my laptop, that command generates 700+ lines of output. When I...
March 21, 2015 at 6:46 pm