I have a daily ETL process in SSIS that builds my warehouse so we can provide day-over-day reports. I have two servers - one for SSIS and the other for the SQL Server Database. The SSIS server ...
Is there a performance advantage to isolating database logs and data on different volumes (same RAID array) across a SAN?
On my old server, I separated them on to different RAID arrays to improve performance. Using a SAN is new to me, so I'm not sure of the optimal configuration. SAN: 48 drives. 10K 600GB SAS. RAID 50. ...
Is there a performance hit when using an external URL rather than an internal IP to address a server in SSIS?
I'm running SQL Server Integration Services (SSIS) packages in SQL Server agent every day. I've been monitoring the performance of the packages and see a lot of network activity in Resource Monitor. ...
I have a bare-bones Windows 2008 R2 Enterprise production server running SQL Server 2008 R2 Enterprise. We have a faster server that isn't being utilized and I'd like to move the production database ...