Hi all,
I have code written in c# that transfers data from msmq and files to mssql.
the one that transfers data from msmq to mssql is deplyed to on serve has following specs
RAM is almost empty, no other heavy process running on system.
Intel Xeon 5140 2.33Ghz 2.67Ghz
Memory 4 GB
MSSQL server 2008
I get message from msmq which is a xml file and read data from it and insert/update it in mssql.
it is insert/update rate is 3 records/min, even if i start from empty table.
while the code that transfers data from file to mssql is deployed on different server and its insert/update rate is 4000-5000/records per min
specs of that server are
RAM is almost full, with lots of other heavy processes running
Intel Xeon 51201.86Ghz 1.86Ghz
Memory 4 GB
MSSQL server 2005
I am unable to find out what the problem is, have you ever encountered such problem
what is the solution.
Thanks
I have code written in c# that transfers data from msmq and files to mssql.
the one that transfers data from msmq to mssql is deplyed to on serve has following specs
RAM is almost empty, no other heavy process running on system.
Intel Xeon 5140 2.33Ghz 2.67Ghz
Memory 4 GB
MSSQL server 2008
I get message from msmq which is a xml file and read data from it and insert/update it in mssql.
it is insert/update rate is 3 records/min, even if i start from empty table.
while the code that transfers data from file to mssql is deployed on different server and its insert/update rate is 4000-5000/records per min
specs of that server are
RAM is almost full, with lots of other heavy processes running
Intel Xeon 51201.86Ghz 1.86Ghz
Memory 4 GB
MSSQL server 2005
I am unable to find out what the problem is, have you ever encountered such problem
what is the solution.
Thanks