All Questions

Filter by
Sorted by
Tagged with
2
votes
1answer
52 views

How to remove Alter, Drop, Create SQL from deployment script created in VS 2015 using SSDT 14.06

I need to remove the below auto-generated deployment script for my SQL project. I am using VS 2015 with SSDT 14.06. Would this be something that can be set in the Advanced Deployment settings under ...
7
votes
2answers
159 views

Increase Max Memory setting on a SQL Server Production

I have a production box with 5 instances on. Version: SQL Server 2014 SP3 Enterprise. I discovered that even though the machine has ~400GB memory assigned, the combined MAX MEMORY settings on all 5 ...
0
votes
1answer
55 views

Installing Anti-Virus on Availability Group databases

Is it worth the risk to use Anti-Virus on Availability Group databases? Even following the guidelines given by Microsoft in How to choose antivirus software to run on computers that are running SQL ...
8
votes
4answers
2k views

MAXDOP Settings for SQL Server 2014

I know this question has been asked number of times and also has answers to it but, I still need a bit more guidance on this subject. Below is the details of my CPU from SSMS: Below is CPU tab from ...
5
votes
2answers
2k views

Configure SQL Server Analysis Services (SSAS) to run on same IP as SQL Server instance

TL;DR I would like to add SQL Server 2014 Analysis Services to a specific instance of SQL Server and to configure it in such a way, that the Analysis Services (SSAS) and future Reporting Services (...
0
votes
1answer
193 views

Tempdb Configuration best practices

I've been asked to provide my input on best practices to improve tempdb performance. I realise that this is a case by case basis and tempdb in one estate may have different requirements to another due ...
4
votes
3answers
85 views

Can a MS SQL Server be named different than host computer?

I have a virtual machine that was built by our IT department to host various processes. They named the computer something incomprehensible like "XYSVC105" and I am not allowed to change it. I have ...
3
votes
1answer
305 views

How to enable CLR on a remote SQL Server?

I have been created a dll for SQL Server 2014 to add some custom functions for my stored procedures for my asp.net websites. I don't have any problem in the local server but can't enable the CLR ...
9
votes
2answers
13k views

Use Dark Theme on SSMS Results Grid, Object Explorer and other windows

There are several ways to use a Dark Theme on SSMS main coding window, either importing a vsettings file, applying Dark Theme that is disabled on a config file or doing it manually. But all those ...
1
vote
1answer
486 views

SSAS and SQL Server optimal settings

I have 4 cubes running on the SSAS server. The CPU seems to peg and we had memory issues with the 4th cube during loads. We have 4 CPUs with MAXDOP set at 2, cost threshold for parallelism = 70. We ...
3
votes
2answers
1k views

SQL Server 2014 Standard Ram and CPU [closed]

I've got a VMWare VM that runs Windows Server 2012 R2, SQL Server 2014 Standard Edition, IIS (hosting custom web application), and SentryOne Monitoring. The VM is configured with 4 cores and 128GB of ...
0
votes
1answer
46 views

In what file does SQL Server Store the configuration data?

Where does SQL Server 2014 store the configuration data? Such as the certificate references for SSL and the size limits and allocations?
6
votes
2answers
611 views

Seperate volumes for tempdb, data, and backups on SQL Servers in VMs

When configuring new SQL Servers on VMs, it is a good idea to have the Database, TempDB, logs, and backups on separate logical drives, even if the underlying storage is the same? I know that this is a ...
0
votes
1answer
589 views

Always on without Listener IP

I joined a new company this week where I noticed that one always on setup has listener ip configured, while the other doesn't. For the AG setup which doesn't have the listener in it, will the ...
1
vote
1answer
457 views

Resource semaphore query compile waits

We have migrated SQL Server Standard Edition from 2008 R2 to 2014. After the migration, we are seeing a huge amount of blocking, and overall the instance is very slow. The major wait we are seeing is ...
1
vote
0answers
1k views

Implementation steps for adding database to an Availability Group

I created implementation steps with fallback plan to add a database to an existing Always On availability group.Can someone please take time and go through the steps and let me know if this ...
-1
votes
2answers
46 views

Always On Stand Alones

Can I add a Stand Alone instance to a Windows Failover Cluster for Always On set up? I need to have one secondary synchronous replica with automatic failover.
1
vote
1answer
248 views

Download the replication snapshot file using FTPS

I have two databases for two companies. Company A's database contains domain data. The other company is pulling the data using snapshot replication. We have used FTP to communicate: Created FTP ...
0
votes
1answer
450 views

Enabling IPAII protocol disable remote conections. Why?

I have some servers with IPAII protocol enabled with a certain port: I'm using 1433 because a long story. but its working. We can use the default port 1433 AND IPAII ( for PHP developers ) with 1433 ...
2
votes
1answer
86 views

Putting SQL Server databases into individual folders

We have a Dev server where we are trying out some automated partitioning scripts. The folder is getting quite large in terms of number of files. Is it possible to automatically have SQL Server use ...
1
vote
1answer
1k views

Azure TempDB and Log files

I'm setting up an Azure D11 SQL Server to be used for a data warehouse. I can only attach 4 data disks and have done so, now I need to determine how to configure them and split the DB files. I'm ...
-2
votes
1answer
2k views

SQL Server 2014 is not showing

I have installed SQL Server 2014 in my machine (OS Windows 10). I already have SQL Server 2008 R2. Now I have 2 server instances and I also have 2 Management Studios. My problem is that I can not ...
2
votes
1answer
15k views

SQL Server service automatically stops after starting

I have a problem with my SQL Server 2014 Express instance. It worked fine until now. I can't get it working because SQL Server service automatically stops immediately after I start it. I'm trying to ...
5
votes
1answer
883 views

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 ...
1
vote
2answers
891 views

Setting max server memory in SQL Server 2014 [closed]

I have a SQL Server 2014 Standard Edition server running Windows 2012 R2, with 128GB memory. I'm attempting to configure SQL Server to use max memory of 96GB, but it appears to not be working. It is ...
2
votes
1answer
319 views

SSAS - what could I monitor in SSAS to fine tune its memory settings?

This question is a follow up from the SSAS - what could be a good starting point for memory settings? What and how can I monitor the server resources in order to best identify the settings that I ...
6
votes
1answer
1k views

SSAS - what could be a good starting point for memory settings?

I have received the following alert regarding memory settings of SSAS: Alert: SSAS 2014: Invalid TotalMemoryLimit Configuration Source: MSSQLSERVER Path: SASBI01Alert time: 9/15/2015 5:38:50 PM ...
8
votes
2answers
8k views

Listing SQL Server instance startup parameters

I have a server I have just restarted and verified which trace flag are active using DBCC TRACESTATUS: Trace Flag : 3688 Function: Removes messages to errorlog about traces started and stopped ...
7
votes
2answers
10k views

Should I use ReFS for a new SQL Server?

We are in the process of building a new production Windows Server 2012 R2 server to run SQL Server 2014 Enterprise Edition. There is a bit of advice on the internet that suggests for Windows Server ...
12
votes
1answer
43k views

SQL Server service account Windows privileges and rights

My question is, if you create a new domain user account for each of the SQL Server processes, what permissions should be set for each account? Or does the SQL configuration manager actually take care ...
1
vote
2answers
1k views

Query cache size in SQL Server 2014

Is there a way to define/set/increase the query cache size in SQL Server 2014 similar to what MySQL has http://dev.mysql.com/doc/refman/5.0/en/query-cache-configuration.html
5
votes
1answer
432 views

Trace Flag 3688 not working on SQL Server 2014

We are using some third party tools that fill up the SQL Server logs with entries like: SQL Trace ID 1 was started by login "sa". SQL Trace ID 2 was started by login "XX\xxxxx". SQL Trace stopped. ...
4
votes
1answer
3k views

Strange behaviours with SET options in SSMS

I am investigating the effect of various SET options on the creation of indexed views on SQL Server 2014 CU1. The following code: ensures that the SET options are as they should be creates a table ...