Viewing 8 posts - 76 through 83 (of 83 total)
Just another question: Are you doing Database mirroring off of this server? We found that heavy use of Mirroring tends to use virtual memory a lot, especially on 32 bit.
Craig
December 19, 2007 at 11:14 am
I suggest you take a look at the white paper: "Troubleshooting Performance Problems in SQL Server 2005". The section on memory tuning /analysis is very good.
Also, using the -g512...
December 19, 2007 at 10:59 am
Is is possible you are trying Log shippng from 2000 to 2005 or vice versa?? In general, they are not compatible.
November 30, 2007 at 5:38 am
Does this help?
http://support.microsoft.com/kb/918483
Based on some of the research I have done, this seems to be an open issue...we saw it on 32bit on Build 3186. Hard coding max/min...
November 29, 2007 at 6:08 pm
This MSDN article is very good:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Also, from a higher level:
http://www.databasejournal.com/features/mssql/article.php/3611426
http://www.databasejournal.com/features/mssql/article.php/3623126
HTH
November 29, 2007 at 5:46 pm
If the Agent is a domain account, check the permissions on the SQL Log directory on both servers. Also check for misconfiguration on the log shipping jobs. Maybe it's trying...
November 29, 2007 at 5:39 pm
I'm not sure if you can do a side-by-side installation. I would script out all logins using the sp_help_revlogin tool and also save DTS packages out on the file system,...
November 29, 2007 at 5:31 pm
We looked at the CommVault block level replication a few years ago. At the time, we were trying to replicate changes in Word documents, not SQL data. It didn't work...
November 29, 2007 at 5:19 pm
Viewing 8 posts - 76 through 83 (of 83 total)