Tag Info

New answers tagged

0

If you installed the 2012 PowerShellTools.msi, then you need to reference SqlServerCmdletSnapin110 (you are specifying SqlServerCmdletSnapin100). Also - it appears sometimes you have to register the DLLs even after running the Power ShellTools.msi install. Take a look at this post for details: ...


1

The 10 GB size limit applies to the database size, and there are separate database for each SharePoint site, so as long as you aren't hosting the data on the site itself you might be ok. However to do that can be tricky, I believe what you would need to do is have an ADFS server (which you will want to provide a better sign in experience for you remote users ...


0

Is your database recovery model Full? Simple? Bulk-logged? I remember upgrading SQL Server 2008 to 2012, and my database that was simple was now set to Full. When I ran the backup, the backup was larger as well since the the Full recovery model also backs up the larger translation logs.


2

When you're using "localhost" notation in fact MySQL uses UNIX domain sockets. They're more performant, comparing to TCP/IP, and for high-load it can make noticeable difference. But UNIX domain is local to the host by its nature, it's not networking, so this implies you can't use remote MySQL server with it.


1

They use a dedicated database server because it's easier to manage. Having dedicated database servers and web servers makes it easier to update, easier to backup, etc. If you have everything for a single customer on a single server you have to run updates and backups on every single instance. By separating them you can have as much customers on a given ...


1

It's not entirely clear to me what you're asking, but I get the impression you're talking about a web server like Apache or nginx running on the same leased server as your MySql database in a hosting provider's data center. You're worried about the connection from the web server to the database, and the only difference between the two choices is what name ...


1

It's very hard to make anything out of your question. I decided that your question is Will a remote database at my provider that I can access via mysql.example.com be slower then a local database that I run on my machine/VPS and that I can access via localhost. The answer is: It depends on many things, among them The specs of your own server/VPS ...


0

I'm guessing you don't have your cluster quorum set correctly, so the cluster goes down when one of the two nodes goes down. Configure a file share witness for your quorum (e. g. http://blogs.technet.com/b/askpfeplat/archive/2012/06/27/clustering-what-exactly-is-a-file-share-witness-and-when-should-i-use-one.aspx) and you should be in better shape.


1

Your intuition is likely correct. You can verify that the SIDs are different between your nodes by running: select name, sid from sys.server_principals on each node and comparing them. As far as how you're supposed to keep them in sync, do so at creation time (unfortunately, there's no way that I know of to change the SID post facto). That is, the create ...


2

You're focusing a bit much on a single metric! Diagnosing a bottleneck to a single component rarely ends with one counter giving a full explanation. There are quite a few great guides for using perfmon to diagnose performance problems on SQL Server. And unfortunately your Admin could be right, the counter you choose does indeed depend on the underlying ...


3

Fairly new to Azure, but here's my offering: The more Azure disks you span the better your performance will be, this is true. I'm not sure about the equation though. Either way, I think you're barking up the wrong tree... Azure imposes artificial limits on metrics such as IOPS and Max reads/writes per second, so the queue length is only one of a few ...


0

I believe the latest versions of Windows Server to support Failover Clustering on Standard Edition - namely Windows Server 2012, and Windows Server 2012 R2.


0

You wrote that you create the required user accounts. As in AD also on sql server the user accounts have a sid that is unique; creating a user with the same name does create a different user. When you restore a database on a different server there are 2 options: script users (with sid and all the background stuff) on the origin server and recreate them on ...



Top 50 recent answers are included