Seems like I posted my original post in wrong topic so putting it here again. Please ignore my old post http://www.sqlservercentral.com/Forums/Topic1413575-1292-1.aspx
as I dont have option to delete it from there..
As I mentioned in my original post :-
I am not understanding this behaviour of SQL Server 2008 (ent ed, sp3cu2). I configured my model database with adequate space so that any new database have default configuration of model.
Now the problem is,
When I am creating it via ssms qizrd, its creating the data and log files as exact of model.
If I run simple tsql as "create database test", it still not creating the data and log file as per model. And also its not consistent of default things which is 3 mb for data and 1 mb for log (initial size). In some environment, this value also changing.
Can someone point me right direction to understand this?
I am not sure about other edition or version but my build level is 10.0.5768.0(sql 2008, sp3cu2) , 64 bit server and 64 bit sql where I am having this issue.
So is this kind of big and is anyone else aware of it?