We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon 
3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server (SQL 
2005).

We have 7 registered CRM users and I think that we do not have more than 2 
concurrent users. Everything seemed to work fine until lately, with no 
particular performance issues. In the last few days however, we detected an 
extremely slowdown and performance degradation. We do not know where to look 
for the cause. We have seen that the SQL server goes up to very high 
CPU-levels when even the simplest action is done by a CRM user.

Any ideas?

I should add that now, we have to wait something like 3 min, in order to get 
the first screen of CRM (it used to be 1-2 secs)!!


"Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message 
news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
> We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon 
> 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server 
> (SQL 2005).
>
> We have 7 registered CRM users and I think that we do not have more than 2 
> concurrent users. Everything seemed to work fine until lately, with no 
> particular performance issues. In the last few days however, we detected 
> an extremely slowdown and performance degradation. We do not know where to 
> look for the cause. We have seen that the SQL server goes up to very high 
> CPU-levels when even the simplest action is done by a CRM user.
>
> Any ideas?
>
> 

Is the SQL Server dedicated to hosting only the MSCRM databases ?  I would 
look to profile the usage of the server using the SQL Profiler tool.

What kind of numbers do you have in terms of contacts, accounts?

Do you find that it is a general slow down or in that particular areas are 
slow?

Reply back if you need particular assistance.
-- 
Rgds

Michael
MCDBA 2000 | MCITP DBA 2005


"Panagiotis Konstantinidis" wrote:

> I should add that now, we have to wait something like 3 min, in order to get 
> the first screen of CRM (it used to be 1-2 secs)!!
> 
> 
> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message 
> news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
> > We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon 
> > 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server 
> > (SQL 2005).
> >
> > We have 7 registered CRM users and I think that we do not have more than 2 
> > concurrent users. Everything seemed to work fine until lately, with no 
> > particular performance issues. In the last few days however, we detected 
> > an extremely slowdown and performance degradation. We do not know where to 
> > look for the cause. We have seen that the SQL server goes up to very high 
> > CPU-levels when even the simplest action is done by a CRM user.
> >
> > Any ideas?
> >
> > 
> 
> 
> 

Thanks for the quick response.

The SQL is not dedicated to MS CRM. It is an SQL of a Small Business Server 
2003, where also other DBs are attached but practically not used.

We are facing an extreme slowdown of the CRM system, which practically 
renders it unusable! As if something were not working properly or taking 
VERY long time to respond (SQL server? IIS? ISA server?) . This has not been 
a gradual slowdown, it's like as if something affected the correct operation 
of the CRM system. Looking at the event log of the system hosting SQL 
server, I see that there is an error about not being able to connect to the 
report server (Event ID 107). Could that be the reason?

Thanks for the assistance.
P.



"Michael Langdon" <MichaelLangdon@discussions.microsoft.com> wrote in 
message news:1E51F3A5-FB92-4758-A645-25F70C7F657A@microsoft.com...
> Is the SQL Server dedicated to hosting only the MSCRM databases ?  I would
> look to profile the usage of the server using the SQL Profiler tool.
>
> What kind of numbers do you have in terms of contacts, accounts?
>
> Do you find that it is a general slow down or in that particular areas are
> slow?
>
> Reply back if you need particular assistance.
> -- 
> Rgds
>
> Michael
> MCDBA 2000 | MCITP DBA 2005
>
>
> "Panagiotis Konstantinidis" wrote:
>
>> I should add that now, we have to wait something like 3 min, in order to 
>> get
>> the first screen of CRM (it used to be 1-2 secs)!!
>>
>>
>> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message
>> news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
>> > We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, 
>> > Xeon
>> > 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server
>> > (SQL 2005).
>> >
>> > We have 7 registered CRM users and I think that we do not have more 
>> > than 2
>> > concurrent users. Everything seemed to work fine until lately, with no
>> > particular performance issues. In the last few days however, we 
>> > detected
>> > an extremely slowdown and performance degradation. We do not know where 
>> > to
>> > look for the cause. We have seen that the SQL server goes up to very 
>> > high
>> > CPU-levels when even the simplest action is done by a CRM user.
>> >
>> > Any ideas?
>> >
>> >
>>
>>
>> 

Hello,

Try also to access the CRM server using the ip-number, and the name of the 
server. Instead of http://crm:5555 try using http://192.168.x.x:5555 or 
http://server03:5555.

I know this sounds a bit strange and it certainly does not explain why the 
CPU level is this high for so olong time. I just want to exclude a DNS issue 
causing this performance problem.

Best regards,

Merijn van Mourik

"Panagiotis Konstantinidis" wrote:

> We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon 
> 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server (SQL 
> 2005).
> 
> We have 7 registered CRM users and I think that we do not have more than 2 
> concurrent users. Everything seemed to work fine until lately, with no 
> particular performance issues. In the last few days however, we detected an 
> extremely slowdown and performance degradation. We do not know where to look 
> for the cause. We have seen that the SQL server goes up to very high 
> CPU-levels when even the simplest action is done by a CRM user.
> 
> Any ideas?
> 
> 
> 

Tracking down a performance issue can take a while to eliminate different 
things.  I would strongly suggest profiling the sql backend and also 
obtaining the MSCRM white paper on performanace tuning.

You do not mention the number of records of entities so would assume you do 
not have that many records.

Your profile needs to be configured to ensure that it does not also impact 
on your system performance.  Check for missing indexes as well.

let me know if I can be of any further assistance.

-- 
Rgds

Michael
MCDBA 2000 | MCITP DBA 2005


"Panagiotis Konstantinidis" wrote:

> Thanks for the quick response.
> 
> The SQL is not dedicated to MS CRM. It is an SQL of a Small Business Server 
> 2003, where also other DBs are attached but practically not used.
> 
> We are facing an extreme slowdown of the CRM system, which practically 
> renders it unusable! As if something were not working properly or taking 
> VERY long time to respond (SQL server? IIS? ISA server?) . This has not been 
> a gradual slowdown, it's like as if something affected the correct operation 
> of the CRM system. Looking at the event log of the system hosting SQL 
> server, I see that there is an error about not being able to connect to the 
> report server (Event ID 107). Could that be the reason?
> 
> Thanks for the assistance.
> P.
> 
> 
> 
> "Michael Langdon" <MichaelLangdon@discussions.microsoft.com> wrote in 
> message news:1E51F3A5-FB92-4758-A645-25F70C7F657A@microsoft.com...
> > Is the SQL Server dedicated to hosting only the MSCRM databases ?  I would
> > look to profile the usage of the server using the SQL Profiler tool.
> >
> > What kind of numbers do you have in terms of contacts, accounts?
> >
> > Do you find that it is a general slow down or in that particular areas are
> > slow?
> >
> > Reply back if you need particular assistance.
> > -- 
> > Rgds
> >
> > Michael
> > MCDBA 2000 | MCITP DBA 2005
> >
> >
> > "Panagiotis Konstantinidis" wrote:
> >
> >> I should add that now, we have to wait something like 3 min, in order to 
> >> get
> >> the first screen of CRM (it used to be 1-2 secs)!!
> >>
> >>
> >> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message
> >> news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
> >> > We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, 
> >> > Xeon
> >> > 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server
> >> > (SQL 2005).
> >> >
> >> > We have 7 registered CRM users and I think that we do not have more 
> >> > than 2
> >> > concurrent users. Everything seemed to work fine until lately, with no
> >> > particular performance issues. In the last few days however, we 
> >> > detected
> >> > an extremely slowdown and performance degradation. We do not know where 
> >> > to
> >> > look for the cause. We have seen that the SQL server goes up to very 
> >> > high
> >> > CPU-levels when even the simplest action is done by a CRM user.
> >> >
> >> > Any ideas?
> >> >
> >> >
> >>
> >>
> >> 
> 
> 
> 

I just tried using http://192.168.0.x:5555  but did not improve the 
situation at all. The response remains extremely slow (minutes for every 
page change!!). It should not be a DNS issue.  On the other hand I am 
getting several ISA server 2004 error messages (Event ID 14079) of the type: 
(Due to an unexpected error, the service fwsrv stpooed responding to all 
requests...). If the firewall is down, then the CRM server and the SQL 
server cannot communicate? Or even the CRM users cannot access the CRM 
server?

By the way, I did try theSQL profiler, but unfortunately I cannot interpret 
the results of the log file. Do you think I should send the profiler log 
file so that you can review it?

Thanks
P.



"Merijn van Mourik" <MerijnvanMourik@discussions.microsoft.com> wrote in 
message news:D060403B-0317-44D6-B344-F6726F82F372@microsoft.com...
> Hello,
>
> Try also to access the CRM server using the ip-number, and the name of the
> server. Instead of http://crm:5555 try using http://192.168.x.x:5555 or
> http://server03:5555.
>
> I know this sounds a bit strange and it certainly does not explain why the
> CPU level is this high for so olong time. I just want to exclude a DNS 
> issue
> causing this performance problem.
>
> Best regards,
>
> Merijn van Mourik
>
> "Panagiotis Konstantinidis" wrote:
>
>> We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon
>> 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server 
>> (SQL
>> 2005).
>>
>> We have 7 registered CRM users and I think that we do not have more than 
>> 2
>> concurrent users. Everything seemed to work fine until lately, with no
>> particular performance issues. In the last few days however, we detected 
>> an
>> extremely slowdown and performance degradation. We do not know where to 
>> look
>> for the cause. We have seen that the SQL server goes up to very high
>> CPU-levels when even the simplest action is done by a CRM user.
>>
>> Any ideas?
>>
>>
>> 

I am more than happy to have a look for you.  You can use the mail address 
michael.langdon@totalise.co.uk
-- 
Rgds

Michael
MCDBA 2000 | MCITP DBA 2005


"Panagiotis Konstantinidis" wrote:

> I just tried using http://192.168.0.x:5555  but did not improve the 
> situation at all. The response remains extremely slow (minutes for every 
> page change!!). It should not be a DNS issue.  On the other hand I am 
> getting several ISA server 2004 error messages (Event ID 14079) of the type: 
> (Due to an unexpected error, the service fwsrv stpooed responding to all 
> requests...). If the firewall is down, then the CRM server and the SQL 
> server cannot communicate? Or even the CRM users cannot access the CRM 
> server?
> 
> By the way, I did try theSQL profiler, but unfortunately I cannot interpret 
> the results of the log file. Do you think I should send the profiler log 
> file so that you can review it?
> 
> Thanks
> P.
> 
> 
> 
> "Merijn van Mourik" <MerijnvanMourik@discussions.microsoft.com> wrote in 
> message news:D060403B-0317-44D6-B344-F6726F82F372@microsoft.com...
> > Hello,
> >
> > Try also to access the CRM server using the ip-number, and the name of the
> > server. Instead of http://crm:5555 try using http://192.168.x.x:5555 or
> > http://server03:5555.
> >
> > I know this sounds a bit strange and it certainly does not explain why the
> > CPU level is this high for so olong time. I just want to exclude a DNS 
> > issue
> > causing this performance problem.
> >
> > Best regards,
> >
> > Merijn van Mourik
> >
> > "Panagiotis Konstantinidis" wrote:
> >
> >> We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon
> >> 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server 
> >> (SQL
> >> 2005).
> >>
> >> We have 7 registered CRM users and I think that we do not have more than 
> >> 2
> >> concurrent users. Everything seemed to work fine until lately, with no
> >> particular performance issues. In the last few days however, we detected 
> >> an
> >> extremely slowdown and performance degradation. We do not know where to 
> >> look
> >> for the cause. We have seen that the SQL server goes up to very high
> >> CPU-levels when even the simplest action is done by a CRM user.
> >>
> >> Any ideas?
> >>
> >>
> >> 
> 
> 
> 

The Report Server is a likely cause of your problems. On most entity views 
and forms CRM will try to connect to Report Server to populate the available 
reports.

A quick test will determine if this is the problem. Do you get quick 
response to the following (none of which should have any involvement with 
Report Server):
- View Sales Literature
- Open a Sales Literature item
- Opening a form to create a new instance of any entity
If these are all quick, but accessing other types of items and views is 
slow, then your problem is with Report Server.

A quick fix (I think) would be to remove permission from users to Reports 
(though this won't help anybody with System Administrator role)
-- 
David Jennaway - Microsoft Dynamics CRM MVP
Web: http://www.excitation.co.uk


"Panagiotis Konstantinidis" wrote:

> Thanks for the quick response.
> 
> The SQL is not dedicated to MS CRM. It is an SQL of a Small Business Server 
> 2003, where also other DBs are attached but practically not used.
> 
> We are facing an extreme slowdown of the CRM system, which practically 
> renders it unusable! As if something were not working properly or taking 
> VERY long time to respond (SQL server? IIS? ISA server?) . This has not been 
> a gradual slowdown, it's like as if something affected the correct operation 
> of the CRM system. Looking at the event log of the system hosting SQL 
> server, I see that there is an error about not being able to connect to the 
> report server (Event ID 107). Could that be the reason?
> 
> Thanks for the assistance.
> P.
> 
> 
> 
> "Michael Langdon" <MichaelLangdon@discussions.microsoft.com> wrote in 
> message news:1E51F3A5-FB92-4758-A645-25F70C7F657A@microsoft.com...
> > Is the SQL Server dedicated to hosting only the MSCRM databases ?  I would
> > look to profile the usage of the server using the SQL Profiler tool.
> >
> > What kind of numbers do you have in terms of contacts, accounts?
> >
> > Do you find that it is a general slow down or in that particular areas are
> > slow?
> >
> > Reply back if you need particular assistance.
> > -- 
> > Rgds
> >
> > Michael
> > MCDBA 2000 | MCITP DBA 2005
> >
> >
> > "Panagiotis Konstantinidis" wrote:
> >
> >> I should add that now, we have to wait something like 3 min, in order to 
> >> get
> >> the first screen of CRM (it used to be 1-2 secs)!!
> >>
> >>
> >> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message
> >> news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
> >> > We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, 
> >> > Xeon
> >> > 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server
> >> > (SQL 2005).
> >> >
> >> > We have 7 registered CRM users and I think that we do not have more 
> >> > than 2
> >> > concurrent users. Everything seemed to work fine until lately, with no
> >> > particular performance issues. In the last few days however, we 
> >> > detected
> >> > an extremely slowdown and performance degradation. We do not know where 
> >> > to
> >> > look for the cause. We have seen that the SQL server goes up to very 
> >> > high
> >> > CPU-levels when even the simplest action is done by a CRM user.
> >> >
> >> > Any ideas?
> >> >
> >> >
> >>
> >>
> >> 
> 
> 
> 

Thanks for the response, but it seems that the problem remains, even for 
tasks that do not require Reporting Services. This does not necessarily 
exclude the effect of the SQL Report Server...

Any other suggestions?



"David Jennaway" <DavidJennaway@discussions.microsoft.com> wrote in message 
news:80EDD77D-5572-48BB-B835-FCE636198D1D@microsoft.com...
> The Report Server is a likely cause of your problems. On most entity views
> and forms CRM will try to connect to Report Server to populate the 
> available
> reports.
>
> A quick test will determine if this is the problem. Do you get quick
> response to the following (none of which should have any involvement with
> Report Server):
> - View Sales Literature
> - Open a Sales Literature item
> - Opening a form to create a new instance of any entity
> If these are all quick, but accessing other types of items and views is
> slow, then your problem is with Report Server.
>
> A quick fix (I think) would be to remove permission from users to Reports
> (though this won't help anybody with System Administrator role)
> -- 
> David Jennaway - Microsoft Dynamics CRM MVP
> Web: http://www.excitation.co.uk
>
>
> "Panagiotis Konstantinidis" wrote:
>
>> Thanks for the quick response.
>>
>> The SQL is not dedicated to MS CRM. It is an SQL of a Small Business 
>> Server
>> 2003, where also other DBs are attached but practically not used.
>>
>> We are facing an extreme slowdown of the CRM system, which practically
>> renders it unusable! As if something were not working properly or taking
>> VERY long time to respond (SQL server? IIS? ISA server?) . This has not 
>> been
>> a gradual slowdown, it's like as if something affected the correct 
>> operation
>> of the CRM system. Looking at the event log of the system hosting SQL
>> server, I see that there is an error about not being able to connect to 
>> the
>> report server (Event ID 107). Could that be the reason?
>>
>> Thanks for the assistance.
>> P.
>>
>>
>>
>> "Michael Langdon" <MichaelLangdon@discussions.microsoft.com> wrote in
>> message news:1E51F3A5-FB92-4758-A645-25F70C7F657A@microsoft.com...
>> > Is the SQL Server dedicated to hosting only the MSCRM databases ?  I 
>> > would
>> > look to profile the usage of the server using the SQL Profiler tool.
>> >
>> > What kind of numbers do you have in terms of contacts, accounts?
>> >
>> > Do you find that it is a general slow down or in that particular areas 
>> > are
>> > slow?
>> >
>> > Reply back if you need particular assistance.
>> > -- 
>> > Rgds
>> >
>> > Michael
>> > MCDBA 2000 | MCITP DBA 2005
>> >
>> >
>> > "Panagiotis Konstantinidis" wrote:
>> >
>> >> I should add that now, we have to wait something like 3 min, in order 
>> >> to
>> >> get
>> >> the first screen of CRM (it used to be 1-2 secs)!!
>> >>
>> >>
>> >> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message
>> >> news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
>> >> > We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800,
>> >> > Xeon
>> >> > 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another 
>> >> > server
>> >> > (SQL 2005).
>> >> >
>> >> > We have 7 registered CRM users and I think that we do not have more
>> >> > than 2
>> >> > concurrent users. Everything seemed to work fine until lately, with 
>> >> > no
>> >> > particular performance issues. In the last few days however, we
>> >> > detected
>> >> > an extremely slowdown and performance degradation. We do not know 
>> >> > where
>> >> > to
>> >> > look for the cause. We have seen that the SQL server goes up to very
>> >> > high
>> >> > CPU-levels when even the simplest action is done by a CRM user.
>> >> >
>> >> > Any ideas?
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>> 

have you checked out the new CRM DB Performance tuning white paper? 
http://www.microsoft.com/dynamics/crm/using

-- 
Anne Stanton, MBSCP-CRM
President, The Norwich Group
The CRM Lady at www.CRMLady.com

-----------------------------------------------------------------------------------------
Written on a Lenovo T60p running VISTA
Tracked in MS Dynamics CRM v3.0 Rollup 1, Outlook Client v3.0C (with hotfix)
Good Neighbor to Groove 2007, OneNote 2007, Office Enterprise 2007, 
Autotask, LinkedIN,
TypePad and More!
-------------------------------------------------------------------------------------------------
"Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message 
news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
> We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon 
> 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server 
> (SQL 2005).
>
> We have 7 registered CRM users and I think that we do not have more than 2 
> concurrent users. Everything seemed to work fine until lately, with no 
> particular performance issues. In the last few days however, we detected 
> an extremely slowdown and performance degradation. We do not know where to 
> look for the cause. We have seen that the SQL server goes up to very high 
> CPU-levels when even the simplest action is done by a CRM user.
>
> Any ideas?
>
> 

are the CRM web server and SQL box on the same network segment ie no 
switches between them?


==============================
John O'Donnell
Microsoft CRM MVP
Web - http://www.crowecrm.com
Blog - http://www.crowecrm.com/crowe/microsoft/crmblog.cfm

"Anne Stanton" <astanton@thenorwichgroup.com> wrote in message 
news:15472716-26E1-4EB5-95BF-A3C693EFFBBE@microsoft.com...
> have you checked out the new CRM DB Performance tuning white paper? 
> http://www.microsoft.com/dynamics/crm/using
>
> -- 
> Anne Stanton, MBSCP-CRM
> President, The Norwich Group
> The CRM Lady at www.CRMLady.com
>
> -----------------------------------------------------------------------------------------
> Written on a Lenovo T60p running VISTA
> Tracked in MS Dynamics CRM v3.0 Rollup 1, Outlook Client v3.0C (with 
> hotfix)
> Good Neighbor to Groove 2007, OneNote 2007, Office Enterprise 2007, 
> Autotask, LinkedIN,
> TypePad and More!
> -------------------------------------------------------------------------------------------------
> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message 
> news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
>> We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon 
>> 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server 
>> (SQL 2005).
>>
>> We have 7 registered CRM users and I think that we do not have more than 
>> 2 concurrent users. Everything seemed to work fine until lately, with no 
>> particular performance issues. In the last few days however, we detected 
>> an extremely slowdown and performance degradation. We do not know where 
>> to look for the cause. We have seen that the SQL server goes up to very 
>> high CPU-levels when even the simplest action is done by a CRM user.
>>
>> Any ideas?
>>
>>
> 

yes, they are on the same segment. More specifically:

CRM server : 192.168.0.20
SQL Server: 192.168.0.1


"John O'Donnell" <csharpconsulting@nospam-hotmail.com-nospam> wrote in 
message news:ePwkBj%23pHHA.4132@TK2MSFTNGP02.phx.gbl...
> are the CRM web server and SQL box on the same network segment ie no 
> switches between them?
>
>
> ==============================
> John O'Donnell
> Microsoft CRM MVP
> Web - http://www.crowecrm.com
> Blog - http://www.crowecrm.com/crowe/microsoft/crmblog.cfm
>
> "Anne Stanton" <astanton@thenorwichgroup.com> wrote in message 
> news:15472716-26E1-4EB5-95BF-A3C693EFFBBE@microsoft.com...
>> have you checked out the new CRM DB Performance tuning white paper? 
>> http://www.microsoft.com/dynamics/crm/using
>>
>> -- 
>> Anne Stanton, MBSCP-CRM
>> President, The Norwich Group
>> The CRM Lady at www.CRMLady.com
>>
>> -----------------------------------------------------------------------------------------
>> Written on a Lenovo T60p running VISTA
>> Tracked in MS Dynamics CRM v3.0 Rollup 1, Outlook Client v3.0C (with 
>> hotfix)
>> Good Neighbor to Groove 2007, OneNote 2007, Office Enterprise 2007, 
>> Autotask, LinkedIN,
>> TypePad and More!
>> -------------------------------------------------------------------------------------------------
>> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message 
>> news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
>>> We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon 
>>> 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server 
>>> (SQL 2005).
>>>
>>> We have 7 registered CRM users and I think that we do not have more than 
>>> 2 concurrent users. Everything seemed to work fine until lately, with no 
>>> particular performance issues. In the last few days however, we detected 
>>> an extremely slowdown and performance degradation. We do not know where 
>>> to look for the cause. We have seen that the SQL server goes up to very 
>>> high CPU-levels when even the simplest action is done by a CRM user.
>>>
>>> Any ideas?
>>>
>>>
>>
>
> 

do you use workflows?

"Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message 
news:OmqOfI6pHHA.4188@TK2MSFTNGP02.phx.gbl...
> Thanks for the response, but it seems that the problem remains, even for 
> tasks that do not require Reporting Services. This does not necessarily 
> exclude the effect of the SQL Report Server...
>
> Any other suggestions?
>
>
>
> "David Jennaway" <DavidJennaway@discussions.microsoft.com> wrote in 
> message news:80EDD77D-5572-48BB-B835-FCE636198D1D@microsoft.com...
>> The Report Server is a likely cause of your problems. On most entity 
>> views
>> and forms CRM will try to connect to Report Server to populate the 
>> available
>> reports.
>>
>> A quick test will determine if this is the problem. Do you get quick
>> response to the following (none of which should have any involvement with
>> Report Server):
>> - View Sales Literature
>> - Open a Sales Literature item
>> - Opening a form to create a new instance of any entity
>> If these are all quick, but accessing other types of items and views is
>> slow, then your problem is with Report Server.
>>
>> A quick fix (I think) would be to remove permission from users to Reports
>> (though this won't help anybody with System Administrator role)
>> -- 
>> David Jennaway - Microsoft Dynamics CRM MVP
>> Web: http://www.excitation.co.uk
>>
>>
>> "Panagiotis Konstantinidis" wrote:
>>
>>> Thanks for the quick response.
>>>
>>> The SQL is not dedicated to MS CRM. It is an SQL of a Small Business 
>>> Server
>>> 2003, where also other DBs are attached but practically not used.
>>>
>>> We are facing an extreme slowdown of the CRM system, which practically
>>> renders it unusable! As if something were not working properly or taking
>>> VERY long time to respond (SQL server? IIS? ISA server?) . This has not 
>>> been
>>> a gradual slowdown, it's like as if something affected the correct 
>>> operation
>>> of the CRM system. Looking at the event log of the system hosting SQL
>>> server, I see that there is an error about not being able to connect to 
>>> the
>>> report server (Event ID 107). Could that be the reason?
>>>
>>> Thanks for the assistance.
>>> P.
>>>
>>>
>>>
>>> "Michael Langdon" <MichaelLangdon@discussions.microsoft.com> wrote in
>>> message news:1E51F3A5-FB92-4758-A645-25F70C7F657A@microsoft.com...
>>> > Is the SQL Server dedicated to hosting only the MSCRM databases ?  I 
>>> > would
>>> > look to profile the usage of the server using the SQL Profiler tool.
>>> >
>>> > What kind of numbers do you have in terms of contacts, accounts?
>>> >
>>> > Do you find that it is a general slow down or in that particular areas 
>>> > are
>>> > slow?
>>> >
>>> > Reply back if you need particular assistance.
>>> > -- 
>>> > Rgds
>>> >
>>> > Michael
>>> > MCDBA 2000 | MCITP DBA 2005
>>> >
>>> >
>>> > "Panagiotis Konstantinidis" wrote:
>>> >
>>> >> I should add that now, we have to wait something like 3 min, in order 
>>> >> to
>>> >> get
>>> >> the first screen of CRM (it used to be 1-2 secs)!!
>>> >>
>>> >>
>>> >> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message
>>> >> news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
>>> >> > We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800,
>>> >> > Xeon
>>> >> > 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another 
>>> >> > server
>>> >> > (SQL 2005).
>>> >> >
>>> >> > We have 7 registered CRM users and I think that we do not have more
>>> >> > than 2
>>> >> > concurrent users. Everything seemed to work fine until lately, with 
>>> >> > no
>>> >> > particular performance issues. In the last few days however, we
>>> >> > detected
>>> >> > an extremely slowdown and performance degradation. We do not know 
>>> >> > where
>>> >> > to
>>> >> > look for the cause. We have seen that the SQL server goes up to 
>>> >> > very
>>> >> > high
>>> >> > CPU-levels when even the simplest action is done by a CRM user.
>>> >> >
>>> >> > Any ideas?
>>> >> >
>>> >> >
>>> >>
>>> >>
>>> >>
>>>
>>>
>>>
>
> 

no, we do not!



"Benjamin Fallar III" <fallar@pldtdsl.net> wrote in message 
news:uFFXSrIqHHA.3968@TK2MSFTNGP06.phx.gbl...
> do you use workflows?
>
> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message 
> news:OmqOfI6pHHA.4188@TK2MSFTNGP02.phx.gbl...
>> Thanks for the response, but it seems that the problem remains, even for 
>> tasks that do not require Reporting Services. This does not necessarily 
>> exclude the effect of the SQL Report Server...
>>
>> Any other suggestions?
>>
>>
>>
>> "David Jennaway" <DavidJennaway@discussions.microsoft.com> wrote in 
>> message news:80EDD77D-5572-48BB-B835-FCE636198D1D@microsoft.com...
>>> The Report Server is a likely cause of your problems. On most entity 
>>> views
>>> and forms CRM will try to connect to Report Server to populate the 
>>> available
>>> reports.
>>>
>>> A quick test will determine if this is the problem. Do you get quick
>>> response to the following (none of which should have any involvement 
>>> with
>>> Report Server):
>>> - View Sales Literature
>>> - Open a Sales Literature item
>>> - Opening a form to create a new instance of any entity
>>> If these are all quick, but accessing other types of items and views is
>>> slow, then your problem is with Report Server.
>>>
>>> A quick fix (I think) would be to remove permission from users to 
>>> Reports
>>> (though this won't help anybody with System Administrator role)
>>> -- 
>>> David Jennaway - Microsoft Dynamics CRM MVP
>>> Web: http://www.excitation.co.uk
>>>
>>>
>>> "Panagiotis Konstantinidis" wrote:
>>>
>>>> Thanks for the quick response.
>>>>
>>>> The SQL is not dedicated to MS CRM. It is an SQL of a Small Business 
>>>> Server
>>>> 2003, where also other DBs are attached but practically not used.
>>>>
>>>> We are facing an extreme slowdown of the CRM system, which practically
>>>> renders it unusable! As if something were not working properly or 
>>>> taking
>>>> VERY long time to respond (SQL server? IIS? ISA server?) . This has not 
>>>> been
>>>> a gradual slowdown, it's like as if something affected the correct 
>>>> operation
>>>> of the CRM system. Looking at the event log of the system hosting SQL
>>>> server, I see that there is an error about not being able to connect to 
>>>> the
>>>> report server (Event ID 107). Could that be the reason?
>>>>
>>>> Thanks for the assistance.
>>>> P.
>>>>
>>>>
>>>>
>>>> "Michael Langdon" <MichaelLangdon@discussions.microsoft.com> wrote in
>>>> message news:1E51F3A5-FB92-4758-A645-25F70C7F657A@microsoft.com...
>>>> > Is the SQL Server dedicated to hosting only the MSCRM databases ?  I 
>>>> > would
>>>> > look to profile the usage of the server using the SQL Profiler tool.
>>>> >
>>>> > What kind of numbers do you have in terms of contacts, accounts?
>>>> >
>>>> > Do you find that it is a general slow down or in that particular 
>>>> > areas are
>>>> > slow?
>>>> >
>>>> > Reply back if you need particular assistance.
>>>> > -- 
>>>> > Rgds
>>>> >
>>>> > Michael
>>>> > MCDBA 2000 | MCITP DBA 2005
>>>> >
>>>> >
>>>> > "Panagiotis Konstantinidis" wrote:
>>>> >
>>>> >> I should add that now, we have to wait something like 3 min, in 
>>>> >> order to
>>>> >> get
>>>> >> the first screen of CRM (it used to be 1-2 secs)!!
>>>> >>
>>>> >>
>>>> >> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in 
>>>> >> message
>>>> >> news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
>>>> >> > We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 
>>>> >> > 1800,
>>>> >> > Xeon
>>>> >> > 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another 
>>>> >> > server
>>>> >> > (SQL 2005).
>>>> >> >
>>>> >> > We have 7 registered CRM users and I think that we do not have 
>>>> >> > more
>>>> >> > than 2
>>>> >> > concurrent users. Everything seemed to work fine until lately, 
>>>> >> > with no
>>>> >> > particular performance issues. In the last few days however, we
>>>> >> > detected
>>>> >> > an extremely slowdown and performance degradation. We do not know 
>>>> >> > where
>>>> >> > to
>>>> >> > look for the cause. We have seen that the SQL server goes up to 
>>>> >> > very
>>>> >> > high
>>>> >> > CPU-levels when even the simplest action is done by a CRM user.
>>>> >> >
>>>> >> > Any ideas?
>>>> >> >
>>>> >> >
>>>> >>
>>>> >>
>>>> >>
>>>>
>>>>
>>>>
>>
>>
>
> 

I'm not convinced that SQL Server is to blame. Is performance terrible on 
the server's console as well? If you're using port instead of name alias to 
get to CRM, try http://localhost:5555 (or whatever port you're using)

-- 
George Doubinski
CRM Certified Professional - Developer


"Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message 
news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
> We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon 
> 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server 
> (SQL 2005).
>
> We have 7 registered CRM users and I think that we do not have more than 2 
> concurrent users. Everything seemed to work fine until lately, with no 
> particular performance issues. In the last few days however, we detected 
> an extremely slowdown and performance degradation. We do not know where to 
> look for the cause. We have seen that the SQL server goes up to very high 
> CPU-levels when even the simplest action is done by a CRM user.
>
> Any ideas?
>
> 

We are thinking of the following alternatives for correcting the existing 
problem:

    1) reinstall CRM 3 on the CRM server (and continue using the existing 
CRM database on the SQL server), or
    2) transfer the CRM db on an SQL server installation on the CRM server, 
or
    3) both tasks mentioned above (1+2), simultaneously.

    Any comments / suggestions?

Regards,
P.

"Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message 
news:OIUKBfUqHHA.4420@TK2MSFTNGP04.phx.gbl...
> no, we do not!
>
>
>
> "Benjamin Fallar III" <fallar@pldtdsl.net> wrote in message 
> news:uFFXSrIqHHA.3968@TK2MSFTNGP06.phx.gbl...
>> do you use workflows?
>>
>> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message 
>> news:OmqOfI6pHHA.4188@TK2MSFTNGP02.phx.gbl...
>>> Thanks for the response, but it seems that the problem remains, even for 
>>> tasks that do not require Reporting Services. This does not necessarily 
>>> exclude the effect of the SQL Report Server...
>>>
>>> Any other suggestions?
>>>
>>>
>>>
>>> "David Jennaway" <DavidJennaway@discussions.microsoft.com> wrote in 
>>> message news:80EDD77D-5572-48BB-B835-FCE636198D1D@microsoft.com...
>>>> The Report Server is a likely cause of your problems. On most entity 
>>>> views
>>>> and forms CRM will try to connect to Report Server to populate the 
>>>> available
>>>> reports.
>>>>
>>>> A quick test will determine if this is the problem. Do you get quick
>>>> response to the following (none of which should have any involvement 
>>>> with
>>>> Report Server):
>>>> - View Sales Literature
>>>> - Open a Sales Literature item
>>>> - Opening a form to create a new instance of any entity
>>>> If these are all quick, but accessing other types of items and views is
>>>> slow, then your problem is with Report Server.
>>>>
>>>> A quick fix (I think) would be to remove permission from users to 
>>>> Reports
>>>> (though this won't help anybody with System Administrator role)
>>>> -- 
>>>> David Jennaway - Microsoft Dynamics CRM MVP
>>>> Web: http://www.excitation.co.uk
>>>>
>>>>
>>>> "Panagiotis Konstantinidis" wrote:
>>>>
>>>>> Thanks for the quick response.
>>>>>
>>>>> The SQL is not dedicated to MS CRM. It is an SQL of a Small Business 
>>>>> Server
>>>>> 2003, where also other DBs are attached but practically not used.
>>>>>
>>>>> We are facing an extreme slowdown of the CRM system, which practically
>>>>> renders it unusable! As if something were not working properly or 
>>>>> taking
>>>>> VERY long time to respond (SQL server? IIS? ISA server?) . This has 
>>>>> not been
>>>>> a gradual slowdown, it's like as if something affected the correct 
>>>>> operation
>>>>> of the CRM system. Looking at the event log of the system hosting SQL
>>>>> server, I see that there is an error about not being able to connect 
>>>>> to the
>>>>> report server (Event ID 107). Could that be the reason?
>>>>>
>>>>> Thanks for the assistance.
>>>>> P.
>>>>>
>>>>>
>>>>>
>>>>> "Michael Langdon" <MichaelLangdon@discussions.microsoft.com> wrote in
>>>>> message news:1E51F3A5-FB92-4758-A645-25F70C7F657A@microsoft.com...
>>>>> > Is the SQL Server dedicated to hosting only the MSCRM databases ?  I 
>>>>> > would
>>>>> > look to profile the usage of the server using the SQL Profiler tool.
>>>>> >
>>>>> > What kind of numbers do you have in terms of contacts, accounts?
>>>>> >
>>>>> > Do you find that it is a general slow down or in that particular 
>>>>> > areas are
>>>>> > slow?
>>>>> >
>>>>> > Reply back if you need particular assistance.
>>>>> > -- 
>>>>> > Rgds
>>>>> >
>>>>> > Michael
>>>>> > MCDBA 2000 | MCITP DBA 2005
>>>>> >
>>>>> >
>>>>> > "Panagiotis Konstantinidis" wrote:
>>>>> >
>>>>> >> I should add that now, we have to wait something like 3 min, in 
>>>>> >> order to
>>>>> >> get
>>>>> >> the first screen of CRM (it used to be 1-2 secs)!!
>>>>> >>
>>>>> >>
>>>>> >> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in 
>>>>> >> message
>>>>> >> news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
>>>>> >> > We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 
>>>>> >> > 1800,
>>>>> >> > Xeon
>>>>> >> > 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another 
>>>>> >> > server
>>>>> >> > (SQL 2005).
>>>>> >> >
>>>>> >> > We have 7 registered CRM users and I think that we do not have 
>>>>> >> > more
>>>>> >> > than 2
>>>>> >> > concurrent users. Everything seemed to work fine until lately, 
>>>>> >> > with no
>>>>> >> > particular performance issues. In the last few days however, we
>>>>> >> > detected
>>>>> >> > an extremely slowdown and performance degradation. We do not know 
>>>>> >> > where
>>>>> >> > to
>>>>> >> > look for the cause. We have seen that the SQL server goes up to 
>>>>> >> > very
>>>>> >> > high
>>>>> >> > CPU-levels when even the simplest action is done by a CRM user.
>>>>> >> >
>>>>> >> > Any ideas?
>>>>> >> >
>>>>> >> >
>>>>> >>
>>>>> >>
>>>>> >>
>>>>>
>>>>>
>>>>>
>>>
>>>
>>
>>
>
> 

The profiler log could provide more info. If you want send it to me, I will 
take a look. My email address: mmourik (at gmail.com). 

"Panagiotis Konstantinidis" wrote:

> I just tried using http://192.168.0.x:5555  but did not improve the 
> situation at all. The response remains extremely slow (minutes for every 
> page change!!). It should not be a DNS issue.  On the other hand I am 
> getting several ISA server 2004 error messages (Event ID 14079) of the type: 
> (Due to an unexpected error, the service fwsrv stpooed responding to all 
> requests...). If the firewall is down, then the CRM server and the SQL 
> server cannot communicate? Or even the CRM users cannot access the CRM 
> server?
> 
> By the way, I did try theSQL profiler, but unfortunately I cannot interpret 
> the results of the log file. Do you think I should send the profiler log 
> file so that you can review it?
> 
> Thanks
> P.
> 
> 
> 
> "Merijn van Mourik" <MerijnvanMourik@discussions.microsoft.com> wrote in 
> message news:D060403B-0317-44D6-B344-F6726F82F372@microsoft.com...
> > Hello,
> >
> > Try also to access the CRM server using the ip-number, and the name of the
> > server. Instead of http://crm:5555 try using http://192.168.x.x:5555 or
> > http://server03:5555.
> >
> > I know this sounds a bit strange and it certainly does not explain why the
> > CPU level is this high for so olong time. I just want to exclude a DNS 
> > issue
> > causing this performance problem.
> >
> > Best regards,
> >
> > Merijn van Mourik
> >
> > "Panagiotis Konstantinidis" wrote:
> >
> >> We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon
> >> 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server 
> >> (SQL
> >> 2005).
> >>
> >> We have 7 registered CRM users and I think that we do not have more than 
> >> 2
> >> concurrent users. Everything seemed to work fine until lately, with no
> >> particular performance issues. In the last few days however, we detected 
> >> an
> >> extremely slowdown and performance degradation. We do not know where to 
> >> look
> >> for the cause. We have seen that the SQL server goes up to very high
> >> CPU-levels when even the simplest action is done by a CRM user.
> >>
> >> Any ideas?
> >>
> >>
> >> 
> 
> 
> 

What is the size of your Log File (ldf) on the sql database?  

"Anne Stanton" wrote:

> have you checked out the new CRM DB Performance tuning white paper? 
> http://www.microsoft.com/dynamics/crm/using
> 
> -- 
> Anne Stanton, MBSCP-CRM
> President, The Norwich Group
> The CRM Lady at www.CRMLady.com
> 
> -----------------------------------------------------------------------------------------
> Written on a Lenovo T60p running VISTA
> Tracked in MS Dynamics CRM v3.0 Rollup 1, Outlook Client v3.0C (with hotfix)
> Good Neighbor to Groove 2007, OneNote 2007, Office Enterprise 2007, 
> Autotask, LinkedIN,
> TypePad and More!
> -------------------------------------------------------------------------------------------------
> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message 
> news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
> > We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon 
> > 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server 
> > (SQL 2005).
> >
> > We have 7 registered CRM users and I think that we do not have more than 2 
> > concurrent users. Everything seemed to work fine until lately, with no 
> > particular performance issues. In the last few days however, we detected 
> > an extremely slowdown and performance degradation. We do not know where to 
> > look for the cause. We have seen that the SQL server goes up to very high 
> > CPU-levels when even the simplest action is done by a CRM user.
> >
> > Any ideas?
> >
> > 
> 

Hi,

I took a look a the log file, compared it with one of my servers. I did not 
find any unusual activity. Hoped it will give some clue.

Best regards,

Merijn van Mourik

"Merijn van Mourik" wrote:

> The profiler log could provide more info. If you want send it to me, I will 
> take a look. My email address: mmourik (at gmail.com). 
> 
> "Panagiotis Konstantinidis" wrote:
> 
> > I just tried using http://192.168.0.x:5555  but did not improve the 
> > situation at all. The response remains extremely slow (minutes for every 
> > page change!!). It should not be a DNS issue.  On the other hand I am 
> > getting several ISA server 2004 error messages (Event ID 14079) of the type: 
> > (Due to an unexpected error, the service fwsrv stpooed responding to all 
> > requests...). If the firewall is down, then the CRM server and the SQL 
> > server cannot communicate? Or even the CRM users cannot access the CRM 
> > server?
> > 
> > By the way, I did try theSQL profiler, but unfortunately I cannot interpret 
> > the results of the log file. Do you think I should send the profiler log 
> > file so that you can review it?
> > 
> > Thanks
> > P.
> > 
> > 
> > 
> > "Merijn van Mourik" <MerijnvanMourik@discussions.microsoft.com> wrote in 
> > message news:D060403B-0317-44D6-B344-F6726F82F372@microsoft.com...
> > > Hello,
> > >
> > > Try also to access the CRM server using the ip-number, and the name of the
> > > server. Instead of http://crm:5555 try using http://192.168.x.x:5555 or
> > > http://server03:5555.
> > >
> > > I know this sounds a bit strange and it certainly does not explain why the
> > > CPU level is this high for so olong time. I just want to exclude a DNS 
> > > issue
> > > causing this performance problem.
> > >
> > > Best regards,
> > >
> > > Merijn van Mourik
> > >
> > > "Panagiotis Konstantinidis" wrote:
> > >
> > >> We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon
> > >> 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server 
> > >> (SQL
> > >> 2005).
> > >>
> > >> We have 7 registered CRM users and I think that we do not have more than 
> > >> 2
> > >> concurrent users. Everything seemed to work fine until lately, with no
> > >> particular performance issues. In the last few days however, we detected 
> > >> an
> > >> extremely slowdown and performance degradation. We do not know where to 
> > >> look
> > >> for the cause. We have seen that the SQL server goes up to very high
> > >> CPU-levels when even the simplest action is done by a CRM user.
> > >>
> > >> Any ideas?
> > >>
> > >>
> > >> 
> > 
> > 
> > 

While implementing the CRM performance optimization guide, I discovered that 
there is a table missing from my CRM db, namely "ActivityBase". There is an 
"ActivityPartyBase" table, though. Could that be causing  the extremely slow 
performance of the the CRM? How can I fix this problem?


"Merijn van Mourik" <MerijnvanMourik@discussions.microsoft.com> wrote in 
message news:C44D3FA9-9B2E-47F1-B854-25AA1F0DED45@microsoft.com...
> Hi,
>
> I took a look a the log file, compared it with one of my servers. I did 
> not
> find any unusual activity. Hoped it will give some clue.
>
> Best regards,
>
> Merijn van Mourik
>
> "Merijn van Mourik" wrote:
>
>> The profiler log could provide more info. If you want send it to me, I 
>> will
>> take a look. My email address: mmourik (at gmail.com).
>>
>> "Panagiotis Konstantinidis" wrote:
>>
>> > I just tried using http://192.168.0.x:5555  but did not improve the
>> > situation at all. The response remains extremely slow (minutes for 
>> > every
>> > page change!!). It should not be a DNS issue.  On the other hand I am
>> > getting several ISA server 2004 error messages (Event ID 14079) of the 
>> > type:
>> > (Due to an unexpected error, the service fwsrv stpooed responding to 
>> > all
>> > requests...). If the firewall is down, then the CRM server and the SQL
>> > server cannot communicate? Or even the CRM users cannot access the CRM
>> > server?
>> >
>> > By the way, I did try theSQL profiler, but unfortunately I cannot 
>> > interpret
>> > the results of the log file. Do you think I should send the profiler 
>> > log
>> > file so that you can review it?
>> >
>> > Thanks
>> > P.
>> >
>> >
>> >
>> > "Merijn van Mourik" <MerijnvanMourik@discussions.microsoft.com> wrote 
>> > in
>> > message news:D060403B-0317-44D6-B344-F6726F82F372@microsoft.com...
>> > > Hello,
>> > >
>> > > Try also to access the CRM server using the ip-number, and the name 
>> > > of the
>> > > server. Instead of http://crm:5555 try using http://192.168.x.x:5555 
>> > > or
>> > > http://server03:5555.
>> > >
>> > > I know this sounds a bit strange and it certainly does not explain 
>> > > why the
>> > > CPU level is this high for so olong time. I just want to exclude a 
>> > > DNS
>> > > issue
>> > > causing this performance problem.
>> > >
>> > > Best regards,
>> > >
>> > > Merijn van Mourik
>> > >
>> > > "Panagiotis Konstantinidis" wrote:
>> > >
>> > >> We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, 
>> > >> Xeon
>> > >> 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another 
>> > >> server
>> > >> (SQL
>> > >> 2005).
>> > >>
>> > >> We have 7 registered CRM users and I think that we do not have more 
>> > >> than
>> > >> 2
>> > >> concurrent users. Everything seemed to work fine until lately, with 
>> > >> no
>> > >> particular performance issues. In the last few days however, we 
>> > >> detected
>> > >> an
>> > >> extremely slowdown and performance degradation. We do not know where 
>> > >> to
>> > >> look
>> > >> for the cause. We have seen that the SQL server goes up to very high
>> > >> CPU-levels when even the simplest action is done by a CRM user.
>> > >>
>> > >> Any ideas?
>> > >>
>> > >>
>> > >>
>> >
>> >
>> > 

We don't have that table either and our installation is performing
normal so I guess its a typo in the guide.

Good luck investigating your problem.

GrandiJoos

On 19 jun, 19:58, "Panagiotis Konstantinidis" <panagio...@melonweb.gr>
wrote:
> While implementing the CRM performance optimization guide, I discovered that
> there is a table missing from my CRM db, namely "ActivityBase". There is an
> "ActivityPartyBase" table, though. Could that be causing  the extremely slow
> performance of the the CRM? How can I fix this problem?
>
> "Merijn van Mourik" <MerijnvanMou...@discussions.microsoft.com> wrote in
> messagenews:C44D3FA9-9B2E-47F1-B854-25AA1F0DED45@microsoft.com...
>
> > Hi,
>
> > I took a look a the log file, compared it with one of my servers. I did
> > not
> > find any unusual activity. Hoped it will give some clue.
>
> > Best regards,
>
> > Merijn van Mourik
>
> > "Merijn van Mourik" wrote:
>
> >> The profiler log could provide more info. If you want send it to me, I
> >> will
> >> take a look. My email address: mmourik (at gmail.com).
>
> >> "Panagiotis Konstantinidis" wrote:
>
> >> > I just tried usinghttp://192.168.0.x:5555 but did not improve the
> >> > situation at all. The response remains extremely slow (minutes for
> >> > every
> >> > page change!!). It should not be a DNS issue.  On the other hand I am
> >> > getting several ISA server 2004 error messages (Event ID 14079) of the
> >> > type:
> >> > (Due to an unexpected error, the service fwsrv stpooed responding to
> >> > all
> >> > requests...). If the firewall is down, then the CRM server and the SQL
> >> > server cannot communicate? Or even the CRM users cannot access the CRM
> >> > server?
>
> >> > By the way, I did try theSQL profiler, but unfortunately I cannot
> >> > interpret
> >> > the results of the log file. Do you think I should send the profiler
> >> > log
> >> > file so that you can review it?
>
> >> > Thanks
> >> > P.
>
> >> > "Merijn van Mourik" <MerijnvanMou...@discussions.microsoft.com> wrote
> >> > in
> >> > messagenews:D060403B-0317-44D6-B344-F6726F82F372@microsoft.com...
> >> > > Hello,
>
> >> > > Try also to access the CRM server using the ip-number, and the name
> >> > > of the
> >> > > server. Instead ofhttp://crm:5555try usinghttp://192.168.x.x:5555
> >> > > or
> >> > >http://server03:5555.
>
> >> > > I know this sounds a bit strange and it certainly does not explain
> >> > > why the
> >> > > CPU level is this high for so olong time. I just want to exclude a
> >> > > DNS
> >> > > issue
> >> > > causing this performance problem.
>
> >> > > Best regards,
>
> >> > > Merijn van Mourik
>
> >> > > "Panagiotis Konstantinidis" wrote:
>
> >> > >> We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800,
> >> > >> Xeon
> >> > >> 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another
> >> > >> server
> >> > >> (SQL
> >> > >> 2005).
>
> >> > >> We have 7 registered CRM users and I think that we do not have more
> >> > >> than
> >> > >> 2
> >> > >> concurrent users. Everything seemed to work fine until lately, with
> >> > >> no
> >> > >> particular performance issues. In the last few days however, we
> >> > >> detected
> >> > >> an
> >> > >> extremely slowdown and performance degradation. We do not know where
> >> > >> to
> >> > >> look
> >> > >> for the cause. We have seen that the SQL server goes up to very high
> >> > >> CPU-levels when even the simplest action is done by a CRM user.
>
> >> > >> Any ideas?

I have decided to re-install CRM, this time on a VMWare image. I will 
install both the CRM and SQL 2005 on the same image, without touching the 
current CRM installation (which is extremely slow).

Is there a way to use the existing CRM db as is, or at least migrate it to 
the new installation? The point is not to lose the data (accounts, contacts, 
etc.) that we have in our (faulty) CRM system.

Any ideas / suggestions?



"George Doubinski" <georged@alexanders.net.au> wrote in message 
news:eF1zlhZqHHA.264@TK2MSFTNGP06.phx.gbl...
> I'm not convinced that SQL Server is to blame. Is performance terrible on 
> the server's console as well? If you're using port instead of name alias 
> to get to CRM, try http://localhost:5555 (or whatever port you're using)
>
> -- 
> George Doubinski
> CRM Certified Professional - Developer
>
>
> "Panagiotis Konstantinidis" <panagiotis@melonweb.gr> wrote in message 
> news:e0W%23To1pHHA.2044@TK2MSFTNGP04.phx.gbl...
>> We have a CRM 3.0 installation on Win2003 SP2 (Dell Poweredge 1800, Xeon 
>> 3GHz, 2GB RAM, 3x73 SCSI on RAID 5). The DB server is on another server 
>> (SQL 2005).
>>
>> We have 7 registered CRM users and I think that we do not have more than 
>> 2 concurrent users. Everything seemed to work fine until lately, with no 
>> particular performance issues. In the last few days however, we detected 
>> an extremely slowdown and performance degradation. We do not know where 
>> to look for the cause. We have seen that the SQL server goes up to very 
>> high CPU-levels when even the simplest action is done by a CRM user.
>>
>> Any ideas?
>>
>>
>
>