Viewing 15 posts - 1 through 15 (of 18 total)
You can try checking your DMV's. here is a good link that should get you started..
March 16, 2011 at 6:19 am
Thinking it might lock the t-log file and put a hold on the script.
March 16, 2011 at 5:51 am
you could, but it would happen in another session, so it might make things worse. You would have to test it. I would rather you put it into...
March 16, 2011 at 5:40 am
Personally i would do this...
RAID 1 = OS
RAID 1+0 = data and log
RAID 1 = tempdb
Test the above for performance. The only other option i can think of, that...
March 16, 2011 at 5:37 am
Are you doing some sort of bulk insert or any large amount of data modification? We had to update 46 millions records in a database a while back and...
March 16, 2011 at 5:20 am
Technically no you shouldn't have any issues because SQL will give back the memory if the OS needs it. But, i have had some performance issues and when i...
March 16, 2011 at 5:09 am
I typically try to keep ALL user data in a file group and only system data in the primary group. We setup file groups for indexes, dynamic data and...
March 15, 2011 at 1:28 pm
When i look at a server for performance this is usually one of the first things i look at to make sure SQL server AND the system has enough memory....
March 15, 2011 at 12:56 pm
you need to make sure you have both versions of .Net loaded, 64bit and 32bit. You might be able to load it via features in the server administrator MMC.
March 15, 2011 at 5:08 am
If you're wanting to backup all databases except for the system databases then select 'User Databases'. This will backup everything EXCEPT the system DB's. So, you will need...
March 15, 2011 at 5:05 am
Thanks Gail, this is the option we are currently coding to use this weekend. It was the by DB option to use if the instance configuration wasn't possible. ...
March 14, 2011 at 8:25 am
The restores are scheduled to use a SSIS package on a remote server so that will disconnect the job.
March 14, 2011 at 8:03 am
make sure your mirroring is synced and the CheckPoints have finished after the backup. We have had similar issues and it's always been one of those two things holding...
March 14, 2011 at 8:02 am
You can right click the DB in SSMS and go to properties. That is how i find it, or are you trying to use T-SQL only? Then you...
March 14, 2011 at 7:59 am
thanks for the quick reply. That is what i am currently doing but would rather set something at an instance level instead of a DB level. The problem...
March 14, 2011 at 7:54 am