Thanks for your response. I'll try working through your suggestions. I appreciate the help.

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...

• This reply was modified 3 years, 12 months ago by  shew.

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...

• This reply was modified 4 years ago by  shew.

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...

• This reply was modified 4 years ago by  shew.
• This reply was modified 4 years ago by  shew.
• This reply was modified 4 years ago by  shew.

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...

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."



Hmmm....

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.

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...

No, I haven't. Can you point me to a link?

Thanks,

J

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...

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...

When I googled the KB's that were installed on 02/24/2015, everyone of them came back with hits on "memory leak."

KB3000483

KB3004361

KB3004375

KB3004394

KB3013455

KB3020338

KB3021952

KB3023562

KB3029944

KB3031432

We're still looking...

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...

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...

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...