Tag Info

Hot answers tagged

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


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


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

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


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


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


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

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



Only top voted, non community-wiki answers of a minimum length are eligible