I didnt receive any memeory dump. SQL server is consumes 6 GB RAM and virtual memory paging also perfect ie assigned 12 GB. Do i need to apply all...
Patch has been applied and minimum server memory has been set to 2 GB.After 10days, we are receiving insufficient error. Any body know woraround for...
I didnt contact microsoft team becuase i dont know about license details. Even client also do not know about... :) .....
Currently we have applied SP4 in SQL server. AWE also enabled with 6 GB max memory. Server has 8 GB RAM but SQL utilized 4 GB ram because of bug. I...
Hi, please find result for moh_hassan20 and today integerity check job also failed with the error Microsoft SQL-DMO (ODBC SQLState: 42000)] Error...
one month before i haved added /3GB and immediately we have found disconnection issues in application. Also we have faced perfomrnace issues in...
Please find memory setting for SQL 2000 enterprise edition. max server memory (MB) 4 2147483647 6144 6144 min memory...
Hi , I have received below erro and one of the application has been terminated same time.SQL Version : 2000 Enterprise EditionService Pack:...
Hi all, I have tried to restore the database from a network share. The backup file size is 350 GB. First 1 hour 30 mins i didnt find any progress...
Hi all, Today i have installed SQL 2005 SP3 but failed with below error. While checking, i found SP3 is applied successfully. i can confirm the same...
Hi all, My environment is SQL 2000 enterprise edition, Windows 2003 Enterprise Edition, 12 CPU and 8 GB RAM. I have done below. 1. Added /3GB /PAE...
Hi Sathya, Thanks for the links, but I am looking for load test. Before move to another one database server, i need to verify whether the serverB...
Did you checked DB auto growth property? may be it is related to DB growth.
Hi all, I have planned to move all databases from serverA to ServerB. Both servers are production server with same collation and same SQL Version....
I hope we can't enable AWE for standard edition (7 and 2000) and also sql cant utilize more than 2 GB. pls confirm?
I want increase SQL Server memory usage from 1800 MB to 2500 MB. Currently SQL Server occupied 1800 MB Ram. Please tell me how to enable AWE in SQL...
I have collected trace files which are occupied more than 2 GB. i did not see any lock escalation in those files. i want to know SQL statements...
Thanks Preethi.... I will enable AWE on next downtime....
i had run SQL profiler with following events, sp:statementstarting, SQL:Statemenstarting, Lock:escalation. I have all trace file. but i need to...
now you can access excel file. you can also download it from another link.
Separate names with a comma.
