Post by urid on Jan 22, 2008 7:48:13 GMT -6
Hi everybody
SharePoint 2007 ,SQL Server (SP2) ---3042
We have seen some strange problems regarding to performance of the web
application.
We have a screen where we do a search for group of users(Pickers) either
defined in SP or Active Directory ,so when I enter the name and pressed OK,
sometimes it takes more than 1-2 minutes. Intresting fact is that if the
user is defined in AD it takes 1 second , as opposite in SP.
1) Run Profiler and have not seen any problems (read/writes/duration)--
(filtered on SharedServices_Search_DB and others)
2) Rebuild Indexes on some fragmented tables in SharedServices_Search_DB and
it IMPROVES performance for the short period.
As it's completely managed by SP, I do not know where to start?
How's it possible that Rebuild helps but have not seen any problems in
Profiler?
Thank you
SharePoint 2007 ,SQL Server (SP2) ---3042
We have seen some strange problems regarding to performance of the web
application.
We have a screen where we do a search for group of users(Pickers) either
defined in SP or Active Directory ,so when I enter the name and pressed OK,
sometimes it takes more than 1-2 minutes. Intresting fact is that if the
user is defined in AD it takes 1 second , as opposite in SP.
1) Run Profiler and have not seen any problems (read/writes/duration)--
(filtered on SharedServices_Search_DB and others)
2) Rebuild Indexes on some fragmented tables in SharedServices_Search_DB and
it IMPROVES performance for the short period.
As it's completely managed by SP, I do not know where to start?
How's it possible that Rebuild helps but have not seen any problems in
Profiler?
Thank you