Viewing 15 posts - 8,446 through 8,460 (of 9,244 total)
out of interest, what are your current min and max memory settings?
how many instances of sql?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2009 at 7:00 am
Steve
yes i read into it that he just wants to test and sanitise the actual restore processes required so if he ever has to do it for real he'll have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2009 at 6:10 am
hey dont get me wrong i like SQL server and as you say price\performance you cant beat it. By flexibilty i am referring to the scalability of the Oracle cluster,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2009 at 4:35 pm
for your user databases, yes. Either backup and restore to the 64bit server or detach\attach the database files.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2009 at 4:14 pm
Andrew Reilly (2/5/2009)
yet when the redundanies came it was all of the most experienced staff (and highest paid presumably) that got the chop.
i've worked for 2 software houses now in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2009 at 3:47 pm
Oracle is by far the most powerful and flexible of the two.
In Oracle RAC the distributed cache memory is shared between the cluster nodes and this offers failover and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2009 at 3:42 pm
Steve Jones - Editor (2/9/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2009 at 2:57 pm
jbloes (2/9/2009)
I couldn't find a free MS Virtual Server...do you have the link?
http://www.microsoft.com/technet/virtualserver/software/default.mspx
you will need to register, thats the only requirement.
Steve (2/9/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2009 at 2:47 pm
select * from ::fn_trace_getinfo(default)
peace2007 (2/8/2009)
My traceid is 2 and fn_trace_getinfo shows nothing for that;)
using the exact command above what traces does it show?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 4:03 pm
SQLBOT (2/8/2009)
My advice is when going 12 GB or higher to ditch the /3GB switch..
the official standpoint is 16GB RAM but i have seen situations where systems with a lot...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 3:53 pm
i wouldnt personally enable\use xp_cmdshell
schedule a windows task to run a batch file. The batch simply copies the file from one location to the other (maybe a mapped drive to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 3:15 am
grab yourself a copy of VMWare server or MS Virtual Server Ent 2005, they're both free.
set up a sql server VM and practice DR on that 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 3:09 am
peace2007 (2/7/2009)
Have you tried running the trace as a server side trace rather than through profiler? That should have noticeably less impact.
1) Start the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 2:51 am
joba
run the trace server side so as not to use too much resource from the server. Either generate the script yourself (search this site for examples and check BOL) or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 2:38 am
Tung
sql2005 standard will address RAM to the operating system max, so no problem there. For a machine with 12GB RAM you may want to remove the /3GB switch from the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 2:34 am
Viewing 15 posts - 8,446 through 8,460 (of 9,244 total)