Tag Info

New answers tagged

2

You could use the Windows System Resource Manager (WSRM) feature for this. It is not present in Windows starting from 2012 R2, but since this is an old SQL 2005, I would expect the OS to be old-ish as well. I've never used it myself, but, though a bit complicated, it might do the trick for you.


1

Assuming the table is called users_access_views and the primary key id is auto increment, Scenario 1) Insert new view and have it be the last view of all the users To insert a new view_id regardless of how many views each user already is assigned to and this new view_id is 3 and ensure the ordinal ranking is obeyed, INSERT INTO users_access_views ...


0

Calculation is something which you need to analyse an figure out with some calculation on basis of that. Kindly go through the below discussion which will help you out in deciding what values you can assign: What is a deterministic method for evaluating a sensible buffer pool size? Also, would recommend to go through below article for indepth explanation: ...


1

If you are content with adding and deleting a view_id per user_id, here is what I see Adding View 12 To User 10 I see three queries Insert new view into user with BogusRank Move all rank down below NewRank Change BogusRank to New Rank for new view Here is the proposed code SET @view_id = 12; SET @user_id = 10; SET @newrank = 3; SET @defrank = ...


1

For bulk operations in index order a larger page size can give a noticeable, sometimes significant, performance increase. For very random access, particularly many small writes, there is similar potential for significant performance reduction. A single read of a 16K block will take four times longer than the read for a 4K block, assuming the drive heads are ...


1

Upon consideration, I can't do what I want to do, better than I am doing it. SQL Server doesn't store what goes where deeper than the filegroup level it seems. From there it's all internals only; and no exposed methods to view. Background links: Round Robin, Proportional Fill and Performance Considerations Understanding the -E Startup Parameter


2

The way that datafiles work, any new data will, mostly, get put in the new data file you added. Or in your case the two new data files. However, SQL Server will not try to re balance your data. This would't make sense either as you will be causing a lot of IO / load on a database for, as far as SQL server knows, no reason. You can however rebalance your ...


4

First and foremost thing, SQL Server in picture is SQL Server 2008 R2 RTM which is not supported by Microsoft in any way please apply SQL Server 2008 R2 SP3 to at least get extended support I analyzed and found that one of the User DB A was using 8 GB RAM I don't think there is any issue because of this, this is totally normal looking at this you ...


0

The word "uniform" is being used to describe the fact that each server should have similar or identical resources, in terms of cpu, memory, disk (seek time, I/O bandwidth), etc. Since a single node can slow down the entire cluster, the slowest node determines the overall capacity of the cluster... so using servers whose performance capabilities are not ...



Top 50 recent answers are included