Tag Info

New answers tagged

2

Setting it to READ ONLY might help you in so far as you are removing one drop of water out of an ocean. Backups take into account active transactions, during the time that the backup is being taken. This means that yes, when you put your database into READ ONLY you are removing a tiny bit of overhead. Which technically does help, but it really isn't worth ...


-2

@BartDeVos is is right to say that it depends on what your bottleneck is, but he's missed the key point which is that IF competing write locks are your bottleneck, then yes, making the database read only can help. (and if not, then don't worry about it). My database expertise is not with Microsoft products, so I can't comment on the particular engine you ...


2

You are using the Express installer. Download the full version ISO.


1

Setting it to read-only will not help you. You would also create downtime for any application that needs write access. Look at where your bottleneck is now. Most of the time it's either 1 of 2 things. CPU is the bottleneck: Don't compress your backup. Disk is the bottleneck: Compress your backup. If you want to dive deeper, run this TSQL Script while the ...


0

You need to run your SQL Setup again on node2 after installing a new cluster on node1. Select the option 'Add a node to a SQL Server failover Cluster' (screenshot from 2012, but the process is the same)


0

I had the same issue. Running exec sp_updatestats did work sometimes, but not always. I decided to use the NOLOCK statement in my queries to speed up the queries. Just add NOLOCK after your FROM clause, e.g.: SELECT clicks.entryURL, clicks.entryTime, sessions.userID FROM sessions, clicks WITH (NOLOCK) WHERE sessions.sessionID = clicks.sessionID AND ...


-2

The first thing I would do is gracefully stop your SQL Server services -- Then make a copy of all the ldf/mdf files on the server. Also find the location of the backup files -- they should be name something like MyDBname_backup_200907220000.bak and rename the extension to something like .hold. That way they aren't wiped out by a maint plan if you have to go ...


0

I had a similar issue. In my case another sw configures the ODBC setting so i cannot change the driver. I solved my case like this: Set TCP/IP settings for server to use the port 1433 On the client enter the server address like: 192.168.1.5,1433 (no instance name) Then it started to work. Client OS: Win7 x64 Driver: sqlsrv32.dll


0

I ran into UNABLE configure Witness for a while, until I realized that the Certificate I used on Mirror's Endpoint was different from Principal's & Witness' endpoint. Once I used the same cert (copied from Principal across to 2nd and 3rd servers) for Mirroring endpoints in Principal, Mirror and Witness, I was able to resolve


2

You are receiving this problem because you have Kerberos half-way configured. You are experiencing a double-hop problem. I've learned a few things about setting up Linked Servers in the past few days. This document on 'How to Implement Kerberos Constrained Delegation with SQL Server 2008' helped me the most. Here are some key points concerning using ...


1

In my experience, Storage Spaces became generally usable for most workloads starting with Windows Server 2012 R2. Before then, it was only worth the effort for specific workloads, like Hyper-V storage. With R2, performance is now on-par with other off-the-shelf SAN and RAID technologies. Monitoring still leaves a bit to be desired and some features like ...


0

Sidenote: I am not familiar with MSSQL, and I don't know if it is possible to run this on Linux. If it is not, you could consider making a VM for Windows on a Linux (or FreeBSD) hypervisor. You could consider running your disk controller in JBOD mode and use the Zettabyte file system (ZFS). With ZFS you can allocate some RAM and SSD's for read (ARC/L2ARC) ...


-1

Storage spaces has a fame to be really slow, so I advise you against using it for database storage. I suggest you to use a RAID 10 array instead. Here you can find some links about that. UPDATE: it seems that with Win2012 R2 Storage Spaces is viable for mirror and stripe configuration. However, it remain very slow for anything involving parity RAID. Here ...


0

There could be many things that are off, like DNS, networking settings etc. A couple of MVP's created a WAP Wiki and OneNote that is a must read when you start implementing azure (pack) http://www.hyper-v.nu/archives/hvredevoort/2015/01/azure-pack-wiki-available-via-onenote/ Hope that provides some useful pointers. The official place for the ...


1

I had the same headache connecting with SSMS from client PC to remote SQL Server. It looks like local firewall was blocking inbound server connection. Problem was solved by assigning inbound rule for SSMS for client PC firewall. The only place I found how to do that was https://msdn.microsoft.com/en-us/library/cc646024(v=sql.120).aspx 1.In Windows ...


0

If you wish to list the collation of each database in an instance, try this: SELECT d.name as DbName, DATABASEPROPERTYEX(d.name,'Collation') AS DbCollation FROM sys.databases d WHERE d.database_id > 4


1

If you want the incremental backups to be retained, the second and subsequent full backups need to be "copy-only" backups, so that the full backup does not break/reset the chain. The solution for #2 requires a competent administrator.


0

For anyone else looking for this the answer appears to be because of "SimpleAD" (http://docs.aws.amazon.com/directoryservice/latest/simple-ad/what_is.html) SimpleAD is supposed to be a free drop-in replacement for Windows Active Directory, but it looks like there are some differences. Tracked down via this forum post: ...


2

If you want to connect remotely to an Azure database, you have to follow these guidelines: https://msdn.microsoft.com/en-us/library/azure/ee336282.aspx. That said, I agree with john: if your application is slow, having it connect to a remote database hosted on a different hosting provider than your VPS (in this case, Azure) is very likely to reduce ...


3

Setting aside the fact that you can't connect to your Azure database from the application on your VPS, do you think this will actually improve performance? You haven't specified who your VPS provider is, but it sounds like they will be in completely different datacenters. Who knows, they could even be in completely different continents! The latency you ...


1

I did exactly what you did - I was adding a new node to an SQL 2014 AlwaysOn cluster and I forgot to uncheck the "Add Storage" button at the end of the wizard. To get the storage back, and your cluster online: Remove all the disks "Cluster Shared Volumes" (Right-click, Remove from Cluster Shared Volumes) Remove all the disks from the cluster completent ...


0

It turns out that the solutions is as simple as specifying a larger timeout. It does matter which timeout though (there are several timeout switches for SqlPackage.exe and it's neither the connection timeout specifiable in a connection string), it's CommandTimeout. The below modified command won't fail even with a bacpac containing a large number of tables ...


0

The resolution to the issue where my Availability Group would stay offline when shutting down one of the SQL Services on a node. I had no idea why this was happening as it was once working. I will just say it was human error. What I needed to do: - Administrative Tools --> Failover Cluster Manager - --> Services and applications --> --> Other Resources ...


-1

By default MSSQL puts the columns and table names in quotes, for MySQL we need to add ANSI_QUOTES to sql-mode. It can be set in my.ini or my.cnf depending on your Operating System. For Windows server 2012 MySQL 5.6, for example, you can find it in C:\ProgramData\MySQL\MySQL Server 5.6. In my.ini, you need to find #sql-mode and update it, adding ...



Top 50 recent answers are included