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.

16 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
325 views

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 ...
3
votes
1answer
356 views

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

AD User does not inherit the permission from AD Group - for a LOGIN

I am having a very tough time figuring out the permissions in my database. My users gain access to the database through reports on SharePoint (via Impersonated authentication configured through ...
2
votes
0answers
377 views

Stolen Server Memory on SQLServer that hosts Sharepoint databases

On one of our servers we have problems with high stolen server memory (around 70% as reported by SCOM). There are Sharepoint databases on the server and there are 2 extended events sesions called ...
2
votes
0answers
1k views

How can I have long waits on Tracewrite, when I haven't run Profiler?

I recently setup a SQL Server which is used only ot run a sharepoint Server. I love to query my wait stats, just to see what we are waiting on. Most of the wait stats are fine, and I know where they ...
1
vote
1answer
45 views

Why SSRS use Share point server for deployment of reports?

I switched from Oracle platform to Microsoft SSRS. Currently I am working on SSRS. What is the use of Share point server for deployment of SSRS reports ?
1
vote
0answers
1k views

SSRS 2008 report fast in test, slow in production: parameter sniffing problem?

We recently had an issue with reports running in an integrated SharePoint environment where the report runs fine in development, test and staging, but very slow (times out) in production. Running ...
1
vote
1answer
160 views

How to backup Sharepoint databases

I am responsible for backups of normal DBs, but SharePoint is handled by others. Bit worried that we miss something here. Is SharePoint backup handled completely through some tool in SharePoint, or ...
0
votes
0answers
37 views

Uploading large files to SharePoint 2016 hangs up the whole server

We started to have an issue while uploading large files (> 6 MB) to an on-premise SharePoint 2016. The whole server stops responding once the file is uploaded to SharePoint (whether thru client ...
0
votes
0answers
30 views

SharePoint changing statistics options daily

SharePoint switches OFF and ON options like AUTO_UPDATE_STATISTICS, AUTO_UPDATE_STATISTICS_ASYNC, AUTO_CREATE_STATISTICS, INCREMENTAL on SharePoint databases daily at 12 AM and that generates lots of ...
0
votes
1answer
28 views

Always On reaction in specific scenario

I need to upgrade my Sharepoint2013 Farm, and the SQL2012 servers are in AlwaysOn mode. I was wondering if I could use Always On in the following catastrophic scenario: Take a VM snapshot of ...
0
votes
1answer
56 views

Find the Sharepoint application server based on Sharepoint Databases

I'm doing some cleanup in my SQL Server farm and I found on one of our SQL servers (2012) several databases that I believe belong to a Sharepoint server. No one knows in the company what is the SP ...
0
votes
1answer
56 views

Shrink configuration & content database in Sharepoint DBs

There was some argument between me and a college about for how we should shrink DBs. We knew that shrinking should be manual and only if required. We run in a case that configuration DBs reached to ...
0
votes
1answer
30 views

SSRS 2012 and SharePoint 2010 Standard

Is it possible to use Report Builder Model, Report Builder Report, Report Data Sources with a Sharepoint Standard 2010 edition?
0
votes
1answer
65 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 (...
0
votes
0answers
962 views

Getting UserInfo data out of Sharepoint via OPENROWSET

The query below returns most of the data from the SharePoint list that my customers want: SELECT * FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0', 'WSS;IMEX=1;RetrieveIds=...