Dear all,

I have one concern that is driving me crazy! I have the same database in two different servers environments, production and development. Production is not exactly one single server, it is a server farm but development is one single database server.

The thing is that the same database is in both server configurations. Inside that database, I have one stored procedure that creates a memory table with one single integer(11) field.

There is one index over that field. This memory table is being loaded with 1.3 million records. The weird thing is: in production that table occupies 64 MB of memory and in development it uses much more less, almost 35 MB.

Anyone can tell me why is that happening if everything is even in both servers? (Data type, index, table structure, data, etc.)

Thanks and regards,
Damian

This may sound crazy as I have seen it one time make a system really slow and I do not know how to turn it off but it may be possible that the larger sized file also contains a back up file, about doubling the size, this is only a guess as I saw it one time only.