Tag Info

New answers tagged

0

This is normal. Max server memory means that your server cannot use more than that amount, not that it must use that amount. Min server memory doesn't mean it must use that amount, either; it means that once the server uses that much it doesn't surrender memory to below that amount. Basically, SQL Server uses the amount of memory it needs until it ...


0

Leave 2GB for the OS then you can split everything to remaining components you can follow this link for more details https://msdn.microsoft.com/en-us/library/ms178067.aspx. You can specify a min and a max by going (from SQL Management Studio to properties).


1

You can script it out similar to this: EXEC sp_Msforeachdb "IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'USERNAME') DROP USER [USERNAME]" GO I've only used it for individual users, not for groups, but it should work.


0

Actually, newer versions of FmPro Migrator also convert the layouts into PHP web applications, as well as other development environments. There is more info available on this web page: http://www.fmpromigrator.com/services/php_conversion.html


0

I have done some reading and by the looks of it, using Resource Governor, you can classify each session/connection and assign it to a particular resource pool. The resource pool is what can limit the resources as you see fit. In order to accomplish this however, you would need to define a classifier function that would look at attributes of the session and ...



Top 50 recent answers are included