Monday, March 19, 2012

Filegroup space diff on 2 servers

I have 2 servers and each have a database which has multiple filegroups
defined. One of this filegroup has 1 table on both server and data from one
is replicated to teh other which means practically same vol fo data on this
filegrroup. However what surprises me is that filegroup space on the 2nd
server is way above than on the first server from where the data is
replicated. Can anyone think fo any reason why there is so much fo
difference. Its abt 3 GB space difference that i notice. any help will be
greatly appreciated.
Message posted via http://www.sqlmonster.com
Probably due to fragmentation. Have you tried reindexing that table?
Andrew J. Kelly SQL MVP
"ishaan99 via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
news:948ed8dbe7094b76b00e1b775c38a7b3@.SQLMonster.c om...
>I have 2 servers and each have a database which has multiple filegroups
> defined. One of this filegroup has 1 table on both server and data from
> one
> is replicated to teh other which means practically same vol fo data on
> this
> filegrroup. However what surprises me is that filegroup space on the 2nd
> server is way above than on the first server from where the data is
> replicated. Can anyone think fo any reason why there is so much fo
> difference. Its abt 3 GB space difference that i notice. any help will be
> greatly appreciated.
> --
> Message posted via http://www.sqlmonster.com

No comments:

Post a Comment