Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sharepoint]

Microsoft SharePoint is a platform and a family of software products developed by Microsoft for collaboration and web publishing. Its capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence. For SharePoint-specific questions, please see the SharePoint Stack Exchange (http://sharepoint.stackexchange.com) site.

For SharePoint-specific questions, please see the SharePoint Stack Exchange site.

Microsoft SharePoint is a software platform and a family of software products developed by Microsoft for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence. This family of products include: Microsoft Office SharePoint Server, Windows SharePoint Services, Microsoft SharePoint Foundation, Microsoft Search Server, Microsoft SharePoint Designer, and Microsoft SharePoint Workspace.

from: http://en.wikipedia.org/wiki/SharePoint

64 questions
13
votes
2 answers

SELECT/INSERT Deadlock

This instance hosts the SharePoint 2007 databases (SP). We have been experiencing numerous SELECT/INSERT deadlocks against one heavily utilized table within SP content database. I have narrowed down the resources involved, both processes are…
SQLJarHead
  • 131
  • 1
  • 1
  • 5
7
votes
1 answer

High CPU in SQL Server supporting SharePoint databases while running FAST search crawl

I have a a SQL Server 2012 (SP1) #cu5 (X64) instance used as SharePoint 2010 back end and for the most part use only 10 - 30% CPU but there is a high CPU usage when running FAST search crawl(both incremental and full ). Following Microsoft…
DaniSQL
  • 702
  • 7
  • 14
7
votes
1 answer

Extremely Slow StatMan query issue with #SP2010 farm

The issue I’m experiencing is explained in a blog-post I created for this, (easy to refer to and to manage the responses / solutions in 1 location) which can be found here:…
Jeroen Schoenmakers
  • 71
  • 1
  • 2
7
votes
2 answers

SharePoint 2013 Database encryption

I'm using SharePoint 2013 with SQL Server 2012 as persistence layer. I need to encrypt the data stored in the database. I stumbled upon the SQL Server feature Transparent Data Encryption (TDE). What will happen to the files (Office Documents) from…
THWaters
  • 73
  • 5
6
votes
1 answer

Attempting to tune a Sharepoint site using SQL Server Waits and Queues

I'm pretty new to this performance tuning with Waits and Queues thing - fascinating, but also not always all that intuitive... Right now, a customer of mine has a SQL Server 2008 64-bit Enterprise Edition, currently with 16 GB of RAM assigned to it,…
marc_s
  • 9,052
  • 6
  • 46
  • 52
5
votes
1 answer

Why is a max degree of parallelism 1 recommended and used for Sharepoint in SQL Server?

I am new to Sharepoint, but I used to work with SQL Server a lot. I realized that Sharepoint changes some of the SQL Server settings to non default values. One is the max degree of parallelism, why doesn't sharepoint like parallel plan executions?…
RayofCommand
  • 1,373
  • 5
  • 15
  • 31
4
votes
1 answer

SQL Server instance running out of worker threads

I have a SQL Server 2008 R2 SP3 Standard Edition 64-bit instance on 8 cores (576 max worker threads) with 32 GB RAM (MaxMem = 28000). It is the data store for a SharePoint installation, with 218 databases. It was getting dozens of "SQL Server failed…
Mark Freeman
  • 2,293
  • 5
  • 32
  • 54
4
votes
4 answers

See who has access to databases via AD group membership

SharePoint has a button to "Check Permissions". Here you can select a user from Active Directory, and it will magically traverse groups and show you all the access the user has on the site based on what groups they are in. This is a long shot as…
SomeGuy
  • 2,053
  • 8
  • 35
  • 48
4
votes
1 answer

SQL Server High Availability and Sharepoint - log file grows when no database activity

Just started as a dba with a company running SQL Server 2012 High Availability and SharePoint. Short description: Database with no user activity still has growing log file. Long description: They have many, many SharePoint dbs where the logfile size…
DiamondBeezer
  • 159
  • 2
  • 11
4
votes
1 answer

What can be done, if anything, to tune a SharePoint database?

SharePoint uses a single table (i.e. dbo.AllUserData) with columns like nvarchar1, nvarchar2, ..., nvarchar64 or int1, int2, ..., int16 (193 columns altogether) to store all items from all lists in all site collections. Can creating new indexes,…
Marek Grzenkowicz
  • 1,495
  • 2
  • 18
  • 27
3
votes
3 answers

SQL Server Permission Denied Error When I'm DBOwner?

So I created an account, gave him dbcreator and securityadmin privileges and then through that account tried to run CREATE TABLE on a database that I had created and now owned, but was getting a permission denied error. Elevating the account to…
tekiegreg
  • 145
  • 1
  • 2
  • 7
3
votes
1 answer

How can INDEX rebuilds be going parallel when MAXDOP is set to 1

I am periodically running into a THREADPOOL wait issue with a SharePoint data store of hundreds of databases using a SQL Server 2008R2 Standard Edition instance (recently migrated to an Azure VM). It is running a stored procedure named…
Mark Freeman
  • 2,293
  • 5
  • 32
  • 54
3
votes
1 answer

Questions Concerning Database Snapshots

One of our divisions is running SQL Server 2012 SP1 Enterprise edition for no particular reason (I know, I know... the decision was made before my time and they are resistant to change). What I'm curious about, since I have a lack of experience with…
SQL_Deadwood
  • 841
  • 3
  • 7
  • 24
3
votes
1 answer

Reduce impact on SQL logs

Sharepoint and SQL Server issue as below When we change setting on SharePoint (Get-SPEnterpriseSearchServiceApplication).QueryLogSettings.CleanupDays = 30 we basically tell SharePoint to purge all data from Search_LinksStore that is older than 30…
Darko Milic
  • 464
  • 3
  • 8
  • 17
3
votes
4 answers

SQL Server 2008 backup script

I have a lot of SharePoint 2013 databases to backup and if update fail to restore, so I want to automate this operations. ALTER DATABASE [TEST_1] SET OFFLINE WITH ROLLBACK IMMEDIATE GO BACKUP DATABASE [TEST_1] TO DISK = 'C:\path\test_1.bak' WITH…
Cove
  • 133
  • 2
1
2 3 4 5