Tag Info

New answers tagged

0

Is there any trace flag enabled or any tweaking into startup parameters of SQL server can you please check that.Have a look at below Microsoft support article http://support.microsoft.com/kb/2199576/en-us Keep max lock value to default EXEC sp_configure 'locks', 0 ( I guess you tried this option already) Now if you face this issue again best possible ...


1

In Oracle (and other RDBMSs), when an SQL statement is run for the first time, it is cached and if somebody else wants to run a similar statement, the plan is taken from the cache - or shared pool. This is called soft parsing and is less costly than going to the trouble of redoing it entirely. So, the term "construct" in this context means an in memory ...


0

pagefile.sys % Usage shows total system committed not what currently is utilized. This value can increase due to load when system finds out it has to back process with more page file. Have a look at below link for detailed explanation http://blogs.technet.com/b/perfguru/archive/2008/01/08/explanation-of-pagefile-usage-as-reported-in-the-task-manager.aspx I ...


0

You have a complex environment with SSIS and SSAS so you have to be cautious with max server memory setting for SQL Server in your scenario Jonathans blogs would not provide complete help. You should refer to below Microsoft link for determining memory requirement for SSIS http://technet.microsoft.com/library/Cc966529#EEAA You should leave enough memory for ...


1

The page faults metric for MongoDB on Windows essentially contains hard (actually hitting disk) and soft (reallocating a pointer in memory) page faults. If you run the same experiment on Linux, the page fault metric only reports hard page faults and you will see the behavior you expect. This is a known issue with the Windows version and the relevant issue ...


1

You should always set your max memory away from default and leave some room for OS (see Jonathan's post of how much Memory to leave based on the amount of RAM installed). Jonathan Kehayias has blogged about : How much memory does my SQL Server actually need? reserve 1 GB of RAM for the OS, 1 GB for each 4 GB of RAM installed from 4–16 GB, and then 1 GB ...


2

In general, a single instance is more efficient, but has inferior performance isolation between databases. If you want maximum throughput and best resource utilisation, put them all in a single instance. One busy DB will be able to affect other DBs more easily this way, especially when it comes to things like high rates of small write transactions. Features ...


1

Your process is sound. Putting the index on the date column will make it much faster for SQL Server to find the rows that it is looking for. Without the nonclustered index SQL Server will need to scan the production table every time you go to delete the rows. This means that SQL will need to load the entire table from disk each time the DELETE TOP 500 ...



Top 50 recent answers are included