Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kuntal
Starting Member
1 Post |
 Posted - 2010-07-22 : 07:53:48
|
| I am facing problem with SSIS. My SSIS package running from command prompt. Upto 2 to 3 days it works very fast.But then it takes so much time to execute a small number of records file. Initially 500 transaction executed in 1 minute , now its take 15 minutes to execute 100 transactions.When I restart server then again it works fine and using 2.40 GB of RAM , after 2 or 3 days it using 3.95 GB of RAM. I enabled AWE property , still it uses 4 GB RAM only. SSRS also runnig on the same server. I am using SQL Server 2008 standard edition (32-bit) Windows Server 2008 Standard Edition (32 -bit) 8.00 GB RAMkuntal |
|
|
fayalif
Starting Member
8 Posts |
Posted - 2010-07-26 : 07:56:03
|
| Right Click on the instance name in Management Studio go to properties. On the properties window select memory from the right side. There you will see maximum server memory list box. In my case, its 500 MB. You can set it according to your need. Hope this will solve your problem.Regards,fayalif |
 |
|
|
|
|
|
SSIS Package Slow