Query with using an Interface between CRM system & SQL Server 2000

We have been experience performance problems on the CRM
system we use which is built on SQL Server 2000. I have
recently started the MCDBA course but do not have enough
experience to answer my own question...
What I have discovered is that all the maintenance of the
tables and relationship have been done through an
interface the CRM System uses which was meant to prevent
my colleagues from having to learn about SQL Server. As a
result when I try to produce diagrams in Enterprise
Manager no links are shown. Do you think this could be an
attribute to the system running slow as I can not see any
relationships between the tables on SQL Server. I think
another reason might be the lack of indexing on some of
the larger tables but any advice you can give would be
great!
Thank you for your time
AnnabelleJust becasue its a CRM database does not mean its been
optinised.
From what you have said there does not seem to be any
foreign keys defined on your system, however you can check
that yourself by
1. Go to EA
2. Select a table that you know should have foriegn key
links
3. Right Click and go to Design Table
4. Press the button on the top of your screen that
says 'Manage Relationships'
Then have a look if any foreign keys have been defined.
A first port of call on speeding up your selected would be
to create a profile then run it through the index tuning
wizard, this will give all the indexs that are needed to
speed things up.
After that you can post specific problems.
Peter
"Happiness is having a large, loving, caring, close-knit
family in another city."
George Burns
>--Original Message--
>We have been experience performance problems on the CRM
>system we use which is built on SQL Server 2000. I have
>recently started the MCDBA course but do not have enough
>experience to answer my own question...
>What I have discovered is that all the maintenance of the
>tables and relationship have been done through an
>interface the CRM System uses which was meant to prevent
>my colleagues from having to learn about SQL Server. As
a
>result when I try to produce diagrams in Enterprise
>Manager no links are shown. Do you think this could be
an
>attribute to the system running slow as I can not see any
>relationships between the tables on SQL Server. I think
>another reason might be the lack of indexing on some of
>the larger tables but any advice you can give would be
>great!
>Thank you for your time
>Annabelle
>.
>