Viewing 15 posts - 5,176 through 5,190 (of 9,241 total)
SQLCrazyCertified (8/13/2012)
I need help from all of you to put together a checklist for troubleshooting disk space issues. In our environment, we get a lot of tickets regarding space...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 10:06 am
you're opening the SQL Server configuration manager program, correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 10:01 am
the DTC is used by many applications including sql server. In SQL Server a dtc is used for remote transactions such as lnked servers and openrowset queries.
A clustered DTC is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 9:47 am
ufcheema (8/14/2012)
Q. 1.====
Let me know how and what to configure for stable SQL 2005 cluster in clustering (mean services etc to be configured in win 2003 cluster).
The installer configures all...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 9:41 am
Your main issue was the syntax error in the calling script.
It won't hurt too much to use page count 8 in your script as your using the results to view...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 9:28 am
that's as maybe, but the idea is to specify port or instance name. Both just serves to cause some people confusion
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 8:41 am
SQLSACT (8/14/2012)
Perry Whittle (8/14/2012)
If <mask> is absent or 0, then no affinitywill be enforced.
:Whistling: 😉
Thanks
What does that mean?
OK, now i'm worried 🙂
if you intend to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 7:25 am
andersg98 (8/13/2012)
At the risk of adding confusion you can connect to an instance using a nonstandard (not dynamic) port and the server name without the browser service.example: Servername.domainname\instancename,port_number
you specify...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 6:54 am
If <mask> is absent or 0, then no affinitywill be enforced.
:Whistling: 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 6:51 am
ajay.g (8/14/2012)
I've a requirement to copy the files from one Server to another Server where they exist on diff. Domains. On first Server, we've administrative privileges with Domain accounts (like...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 5:55 am
well firstly, each of the runs really needs to run for longer than 5 seconds to get any real metrics 😉
What are the results that are produced from the runs...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 5:41 am
can you supply details of the config file you are using
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 2:40 am
tilew-948340 (8/13/2012)
Perry Whittle (8/13/2012)
use this to delete backup\restore history for a specific database
use msdb;
go
exec sp_delete_database_backuphistory @database_name = 'yourdbname'
Seems to do the job!!!!
Thank you very very much!!!
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 2:37 am
The index procedure in Olas script outputs to a table have checked this table for any results?
It may be possible that no indexes are found for defragging in this particular...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 12:21 am
Cairbre (7/9/2009)
I've been told by our architect/infrastructure guys that adding more LUNs will help.
Hmmm, yes. Pushing more I\O queues down to the disks will likely just saturate them, then your...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2012 at 4:02 pm
Viewing 15 posts - 5,176 through 5,190 (of 9,241 total)