Improving performance will gv ur work good
SSIS, for performance improving we need to use less component in data flow items, for example in place of using data conversion component u can use a type cast in derived column. same for character map,and kp the buffer size 1000.so that moving of data to the btree buffer memory will b easier,and try to implement always parallel execution of data, use a SQL select statement to retrive data from a view or table except unused column,and one more if u r using look up then use partial or full catch mode.These are some tips in SSIS
coming to SSRS part many of reports are memory-intensive so try to use 64 bit option.Reduce the size of the dataset.Simplify the grouping, filtering, or sorting logic in the report to use less memory, if ur stored procedure taking time try to reduce in query level.and try to kp timeout in connection string between 3000 to 6000.u can type manually in connction string.
So these are the properties u can follow up.
SSIS, for performance improving we need to use less component in data flow items, for example in place of using data conversion component u can use a type cast in derived column. same for character map,and kp the buffer size 1000.so that moving of data to the btree buffer memory will b easier,and try to implement always parallel execution of data, use a SQL select statement to retrive data from a view or table except unused column,and one more if u r using look up then use partial or full catch mode.These are some tips in SSIS
coming to SSRS part many of reports are memory-intensive so try to use 64 bit option.Reduce the size of the dataset.Simplify the grouping, filtering, or sorting logic in the report to use less memory, if ur stored procedure taking time try to reduce in query level.and try to kp timeout in connection string between 3000 to 6000.u can type manually in connction string.
So these are the properties u can follow up.
nice post
ReplyDelete