Viewing 15 posts - 181 through 195 (of 392 total)
have you enabled AWE
AWE is enabled. /PAE switch is turned on as is lock pages in memory.
Steve
March 14, 2011 at 6:15 am
I would suggest that you start by reading Gail Shaw's article today about this subject. http://www.sqlservercentral.com/articles/Transaction+Log/72488/
February 21, 2011 at 10:02 am
Tom,
Putting everything on one array will almost always be completely wrong. Tempdb should probably have an array to itself, and the transaction log certainly should. How many other arrays are...
February 18, 2011 at 6:50 pm
Tom
I strongly recomment reading BAARF Manifesto and the various things linked from there
Sorry, after reading a majority of things on BAARF, we will have to agree to disagree....
February 18, 2011 at 12:40 pm
Tom.Thomson
dev-638705
Nice question, although RAID5 is a not really a good choice for databases ! (except limited cases with mostly read-only databases).
Better use RAID 01 (i.e. RAID0-aggregate of RAID1-mirrored drives),...
February 18, 2011 at 10:06 am
We have gone through the pains of having everything on the SAN, and when there were performance issues the SAN vendor kept saying throw more devices at it. Performance might...
February 18, 2011 at 8:04 am
Lynn
rob.lobbe (9/15/2009)
--------------------------------------------------------------------------------
This works if you are the ONLY one using the database.
Running in a production system you can't just go about changing the recovery model.
as for a 'batch' delete
select 1
while...
February 18, 2011 at 6:41 am
What is in the error log and the event viewer for the server? We need more information otherwise it is solely speculation.
February 14, 2011 at 12:25 pm
In your SSMS, under Management you will see SQL Server Logs. By default there will be 6 of them, with the most current one being labled as such.
Review the entries...
February 14, 2011 at 7:46 am
mw
Let me make it simple.
When I started the "RESTORE.." I used the query window in SSMS.
Then 4 hours later when I logged back into the server I did not see...
February 14, 2011 at 7:24 am
mw
restore database NGProd
from disk = N'D:\Backups\NGProd.bak' with file = 1,
move 'NextGen_System_Data' to 'D:\Databases\NGProd\NGProd_System_data.mdf',
move 'NextGen_Core_Data_1' to 'D:\Databases\NGProd\NGProd_Core_Data_1.ndf',
move 'NextGen_Index_1' to 'D:\Databases\NGProd\NGProd_Index_1.ndf',
move 'NextGen_Log' to 'D:\Databases\NGProd\NGProd_Log.ldf',
recovery,
stats = 10;
As an FYI - placing...
February 14, 2011 at 7:03 am
Cheshire,
One of the issues that I recently got hit with was:
Setting up a central distributor, I had 64 stores with 1 publication being replicated to 1 subscriber. I also wanted...
February 9, 2011 at 7:52 am
Great question Steve - missed it, but the education on CLR's continues.
February 9, 2011 at 7:32 am
drop all indexes then BCP in data (fast bcp). After BCP is done recreate the indexes
This does not reduce the size of the transaction log. As was previously stated, the...
February 1, 2011 at 8:32 am
Craig,
I agree with everything that you said, but many times when pushed these vendors can use dbo access. They prefer SA because it is easier for them. I have had...
January 31, 2011 at 12:11 pm
Viewing 15 posts - 181 through 195 (of 392 total)