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 |
|
JoseVds
Starting Member
2 Posts |
 Posted - 2011-03-08 : 08:54:40
|
| I have constructed a database with some assistance, and I am at the point of testing my Database model.I am trying to run multiple copies of my DB with different configurations for testing purpose.If I run as a single (on it’s own) is OK. But with the DB running multiple versions, I am getting memory leak’s on my API. (the cause been the .NET runs as a single thread and is tacking to long to run the .NET across various DB models.)Beside setting up my computer with a set of Virtual Systems and run one DB on each Virtual system, so that I run each DB model on it’s own .Net, is there alternative options I could use to run this application with different setup’s. I.e. setting up different registered DB and run each of the DB models on different registered DB. Those the .Net then be able to work separately from the other?Thank you |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-03-08 : 13:16:07
|
| There is no reason why you should not be able to connect to multiple databases from a single thread without causing memory leaks, as long as you release unmanaged objects (and of course use managed objects wisely).1. How are you connecting to the DB? ADO? ADO.Net? LINQ? something else?2. What indication do you have that suggests memory leak? |
 |
|
|
JoseVds
Starting Member
2 Posts |
Posted - 2011-03-08 : 14:33:48
|
| Hi sunitabeckMy DB model receives update through the API (Market update of price changes) , this can happen several times per second. The API generates a thread that request a STORE-Procedure to run.The Store procedure runs through a set of calculation to generate the results (in a .NET environment). I am hijacking the process to copy the update to 2 other models (with different configuration) and executing the results of each of the three models to the original process to do the final calculations based on the previous results. (The other processes are just models to evaluate/comparison to the current, kind of Lab-X model).The duration of the single thread process in the .NET is too long for the updates I am receiving from my API and this is from the time I began the LAB process (that is same program/but different configuration).It all runs well, until the API run’s out of memory (i.e. 32 bit and 2 GB limitation (that is on my API at 1750 MB range, originally starts at 17KB).One option I have is to load virtual machine and operate each of the model’s in separate virtual machines and the API to feed to all of the TEST MODELS.( that may require to replace my current computer )I am seeking alternative answer’s before I replace with a large system to run in virtual system. |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-03-08 : 14:49:46
|
| Jose, from your description, the architecture and the processes are too complex for me to understand and make any useful suggestions. The memory leak does not seem to be related to the database accesses. If I had to make a wild guess(*), I would start with the accumulated price updates chewing up the memory. If that indeed is the case you might want to consider a multi-threaded model. (*) emphasis on "WILD" |
|
|
|
|
|
|
|
|
SQL Server and .NET operation