Ninja's_RGR'us (2/8/2011)

---

Svs2010 (2/8/2011)

---

@Ninja's- Yes we are thinking of getting the latest version only and have to make sure all other SQL servers can be upgraded and the applications supports them...

@ninja's- Yes we are thinking of getting the latest version only and have to make sure all other SQL servers can be upgraded and the applications supports them...

@steve-2 - Thanks for ur reply as well.

The main base line for this plan is cost cutting. Instead of paying for 6 different sql licenses, thinking of spending...

Thanks to all for the replies.

@Minaz amin - Like I had mentioned above, each application has its own Sql server so the current configuration of each SQL server is differing...

Have you tried the above change? Did it help you?

I am having exactly the same problem. The SSIS package is running fine from BIDS but, when scheduled it to run...

No reply from any body? :unsure:

Thanks for the update. ours is a dedicted server.

then how can i trouble shoot the issue that sql is freezing up some times?

Gail Shaw,

Server has total of 3.12 GB memory and from which sqlservr.exe is taking 1.7gb which is the maximum among all the processes that r running at that time.

I have...

Yeah! I have checked those settings, and yes "Dynamically configure Sql server memory" has been checked. Can I change these settings? if yeas what would be the best amount to...