Showing posts with label hardware. Show all posts
Showing posts with label hardware. Show all posts

Monday, March 12, 2012

im a newbe. please help

i'm turning up a replicated SQL SVR database environment on dedicated hardware. other than the instance name, all database will be exactly the same. my question is, is it possible to export, or copy scheduled jobs from the first database environment to the newly created environment? i'd like to avoid having to recreate all of them, if possible.Generate SQL script from existing job, then execute the script in your new environment.|||Or use DTS (Data transformation services Wizard) , local packages, select the transfer job task then follow the wizard.

IL3 Cache Recommendations and Explaination

Can someone point me in the right drections?
I need detailed info on the benefits of IL3 Cache when considering new
hardware.
Thanks,
-BenSee:
http://www.sql-server-performance.com/jc_processor_performance_update.asp
http://www.2cpu.com/articles/99_1.html
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Ben" <bmilliron@.gmail.com> wrote in message
news:O3dNLmekEHA.3152@.TK2MSFTNGP12.phx.gbl...
> Can someone point me in the right drections?
> I need detailed info on the benefits of IL3 Cache when considering new
> hardware.
> Thanks,
> -Ben