在执行SSIS包时,我得到了以下错误:
The buffer manager failed a memory allocation call for 10484608 bytes, but was unable to swap out any buffers to relieve memory pressure. 20 buffers were considered and 20 were locked. Either not enough memory is available to the pipeline because not enough are installed, other p
最近,我们将表转换为内存优化数据。我们的备份已经膨胀(3x300GB文件到3x600GB文件完整,3x50GB到3x250GB,用于Diffs),并且启动速度越来越慢。错误日志最初是每20秒更新一次恢复状态,预测分析大约需要9天才能完成,但大约一个小时后,更新就停止了。SP_WHO2只显示一个使用命令XTP_DB_RECOVERY访问数据库的进程,但是SELECT * FROM sys.dm_db_xtp_checkpoint_files不返回任何行。或者如何查看这个XTP_DB_RECOVERY命令估计