Viewing 15 posts - 8,566 through 8,580 (of 9,244 total)
have you tried opening the job remotely through SSMS on another machine?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 12:31 pm
a compatibility version of 80 doesnt mean you can restore the database back to sql2000.
as previously pointed out you would be well advised to make sure that both environments use...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 10:35 am
interesting links, so basically if it all went horribly wrong and 1 file filled up for some reason all the data would be written to just 1 remaining data file....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 10:22 am
Richard Hall (12/29/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 10:05 am
Steve's topic at the following link should get you started
http://www.sqlservercentral.com/articles/Administering/performancemonitoringbasiccounters/1348/
also check out Brad McGehee's topics on this subject. A google search should provide the link for that
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2008 at 4:05 am
installs as a named instance if sql is already on the machine. Re run the setup and select Analysis Services
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2008 at 4:34 pm
while its true that with RAID10 a failure of a mirrored pair is terminal. Because of the amount of disks required for RAID10 its a sort of safety in numbers...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2008 at 4:31 pm
is it absolutely necessary that node 3 has 4 instances of SQL. This will affect the RAM configuration on that node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2008 at 3:41 pm
kendal.vandyke (12/28/2008)
Perry Whittle (12/28/2008)
jlp3630 (12/27/2008)
Assuming that the system was running, how would you go about systematically getting baselines for reads/writes?
as you say, depends if the system is already live. If...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 28, 2008 at 12:25 pm
try the following query
select @@servername, serverproperty('servername')
what is the result
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 28, 2008 at 6:09 am
jlp3630 (12/27/2008)
Assuming that the system was running, how would you go about systematically getting baselines for reads/writes?
as you say, depends if the system is already live. If your scoping new...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 28, 2008 at 5:30 am
Matin (12/26/2008)
Hi All ,How to trace sql sp without using print() statement ?
Thanks in advance
best way!
run a server side trace and dump the output into a sql table
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 27, 2008 at 9:10 am
truncating the log will remove any inactive entries but not reduce the actual physical file size.
shrinking the log will reduce the physical file size,
but it's worth noting you cannot...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 27, 2008 at 8:58 am
if the browser is running it does yes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 26, 2008 at 3:28 pm
i seem to remember, initial contact is made over 1433 then the server passes back the details of the named instance(s) and its ports\IP address
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 26, 2008 at 3:43 am
Viewing 15 posts - 8,566 through 8,580 (of 9,244 total)