Did you find any solution for this rebuilding indexes?

did you change the fill factor?

can we do rebuid index task for sharepoint databases in sql server

http://support.microsoft.com/kb/932744/ this link says we can...

Thanks Gail,

I just checked the Sharepoint documentation in http://support.microsoft.com/kb/932744/.

I have question here about rebuid an index.

As per the link, I did not understand whether I can rebuild the indexes...

Thank You,

We have a database wss_content and its primary data file is located in E:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\wss_content.mdf and log file is located in F:\SQLLogs\wss_content_log.ldf.

The database size is 30GB. Now, how...

Sql server agent is running fine and the jobs are also running fine But still Iam getting this 15281 error

Plz advice me

Hi All,

We successfully installed SP3 on clustered environment with no issues in production. We have a/a/p cluster setup,On node1 we have 1 instance and node 3 we have 4 instances....

anybody applied SP3 in cluster environment. If you did, did you get any issues?

Can we make a system restore point and apply SP3, and if any thing goes wrong can...

In general when we install sql server 2005, which is going to store sharepoint databases, do we need to choose the collation settings as collation: Latin1_General_CI_AS_KS_WS instead of default...

Hi,

Could you plz clarify me this thing as we are going to apply SP3 in production servers in cluster environment.This is the only thing,where Iam not sure what to...

Hi Gail,

Is these dead locks are anyway related to having different collation settings.

we have sharepont databases,which will be installated by default with collation settings of Latin1_General_CI_AS_KS_WS. But when we installed...

Hi,

We have the drives E,F,G as resource dependies for the instance INS1. I did not remove these drives or take them offline. I installed SP2 as as well as...

Thanks Gail,

So there is no way we can reduce the frequeny of getting dead locks in this scenario?any thing we can advice to the sharepoint admin to avoid this deadlocks?

thank you very much.....now Iam confident to set all the configuration settings.

I really appreciate your detailed explanation.

Hi,

From BOL,

Failover clustering performance benefits from generous memory allocation. The theoretical maximum memory is the total memory available, less memory for the operating system and the other cluster and local-to-node...

Hi,

We want to set max memory size to 12GB out of 16 GB RAM. I set the max memory 12 GB and restart the server, immediately I can see that...

whats the last point

Rolling upgrade is not supported for SP3 means?could you give some more info on this