July 14, 2009 at 10:56 pm
hi all,
We have SQL Server 2000,
RECently i have added new filegroup to database.After successful creation and deletion of cluster index on new filegroup.
I ran query.
select o.[name],i.[groupid] from sysobjects o,sysindexes i where i.[id]=o.[id]
OUTPUT WAS STRANGE:
NAME GROUPID
AGCY 1
AGCY 1
AGCY 1
Arrange 1
Arrange 1
Arrange 1
ComRate_History 2
ComRate_History 1
ComRate_History 1
ComRate_History 1
ComRate_History 1
ComRate_History 1
(i cant post all tables as there are more than thousand tables)
In above result we can see one table given by sql three times or some even more.
can anyone tell me why this is happening?how to get over with this problem.
Thanks,
Nero
July 15, 2009 at 7:51 am
Hi,
Did you checkout sysindexes and sysobjects tables individually whether you have any duplicates. I think you did not move your indexes correctly. Can you post the code which you had used to move to new filegroup.
[font="Verdana"]Thanks
Chandra Mohan[/font]
July 15, 2009 at 7:54 am
Hi
I think its nothing strange. If you have multiple indexes on a table then it will definitely show repeating table names.
Use the below query
select o.[name],i.[name],i.[groupid] from sysobjects o,sysindexes i where i.[id]=o.[id] order by o.[name]
[font="Verdana"]Thanks
Chandra Mohan[/font]
July 15, 2009 at 10:06 pm
hi,
I did using SSEM..
HOW THIS GOING TO AFFECT MY DB PERFORMANCE?
We have OLTP system our db slows after certain point.To rectify this we have to delete log.But this is temporary.
Any suggestion to recetify this problem.We have ONE MDF AND ONE LDF ONLY.
WHAT i did is
Create NEw filegroup
Add one NDF
And put cluster index on heavy data table to new filegroup using SSEM and deleting them after creation.
Thanks,
NERO
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply