0
votes
1answer
16 views

Deploy SSRS 2012 report to a distant Sharepoint 2010 server

My installation : - SQL server 2008 r2 + Sharepoint server (main farm) = VM1 - SQL server 2012 + SSRS 2012 (not native mode) = VM2 I would like, if possible , make my SSRS configuration manager ...
1
vote
1answer
44 views

Dealing with large transaction logs in a cluster

Disclaimer: I'm a dev, not a DBA. I've gleaned what I can from MSDN, but could do with some expert guidance! I'm working with a SharePoint 2013 installation on a SQL Server 2012 cluster of two DB ...
2
votes
0answers
454 views

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 ...
0
votes
0answers
1k views

SQL Server 2012 SSIS\SharePoint Kerberos auth [closed]

I have some issues setting up Kerberos together with SQL Server and SharePoint. Any help will be much appreciated! =) GOAL: Use Kerberos to avoid double-hop issue. USAGE: User logs onto ...
4
votes
2answers
1k views

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 ...
0
votes
0answers
142 views

C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\DATA [closed]

I am trying to query SharePoint list data from a database named like STS_bangbus_1 database, but there seem to be only one SQL Server instance with the named “bangbus” aka “SHAREPOINT”, with ...
1
vote
2answers
703 views

Consistency errors for a SharePoint database

When I check my database (SQL Server 2008 R2, Windows Server 2008 R2, SharePoint 2007 DB) with the command: DBCC CheckDB I get 12 consistency errors (see below). Is the only way to fix it with ...
2
votes
1answer
233 views

Can I create a second filestream container on an existing SQL Server 2008 database without going offline?

Our production DB is using the FILESTREAM option for our sharepoint environment. The volume where the files are residing is getting full and I am planning to add another volume to ease space issues. ...
1
vote
0answers
319 views

How to manage SQL Server Log file? [closed]

I have an application build on SharePoint 2007 platform, and currently I encounter a common issue where the Database Log file growth rapidly and fill up the hard disk space. In my situation, I wanted ...
1
vote
2answers
463 views

maintenance plan executing by agent

I have a built-in, regular maintenance plan scheduled to run weekly. The databases are SharePoint databases and a snap manager (netapp snap manager) backs up these databases. The rebuild ...
4
votes
1answer
457 views

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 ...