Viewing 15 posts - 8,566 through 8,580 (of 9,241 total)
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
Vista users run as low privelege normally, what does sql authentication produce running the same statement?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 25, 2008 at 11:49 am
Lynn Pettis (12/17/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 25, 2008 at 11:42 am
fputhod (12/22/2008)
I installed from a internet download
from where exactly?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 25, 2008 at 11:37 am
Viewing 15 posts - 8,566 through 8,580 (of 9,241 total)