Viewing 15 posts - 121 through 135 (of 457 total)
I'm guess that your monitoring software alerts when your Disk Queue Length hits 2.
The no of disk that make up the array that hosts the z:\ drive need to...
February 19, 2010 at 3:45 pm
If the database is log shipped then you will not be able to run SP_CHANGE_USERS_LOGIN as this requires the database to be online for writes, a logshipped db is either...
February 19, 2010 at 2:04 pm
george sibbald (2/18/2010)
SQL Server MVP Deep dives - some of the purchase price goes to charity as well.
This is a great book.
I also quite like SQL Server 2005 Unleashed by...
February 18, 2010 at 8:43 am
Jeffrey Williams-493691 (2/17/2010)
GRE-452109 (2/17/2010)
Just to sound like an echo, backup the systems databases (Master, Model, MSDB) on a regular schedule.
Not true - in a disaster recovery scenario you will probably...
February 17, 2010 at 4:43 pm
I have got production SQL boxes on ESX and vSphere I find it very good, not really looked at Microsoft's HyperV option in any real detail though.
February 17, 2010 at 4:14 pm
GT-897544 (2/17/2010)
Yes\No, because it is very rare you restore system databases, but no harm in taking system databases as they take little space. Include them in maintenance job.EnjoY!
Its rare to...
February 17, 2010 at 4:03 pm
The three SQL Agent jobs should be failing and giving an error, can you post the error that these are giving?
Also is there anything untoward in the SQL error log?
February 17, 2010 at 3:54 pm
Just to sound like an echo, backup the systems databases (Master, Model, MSDB) on a regular schedule.
February 17, 2010 at 3:38 pm
I don't think it has been yet, I checked today and it wasn't available. It would most likely be under the virtualisation chapter though, not the DBA one
February 16, 2010 at 4:44 pm
If you have the kit, then a two node multi-instance (Active/Active) cluster could be the way to go, That said each individual node needs to be able to run...
February 16, 2010 at 2:54 pm
Is clustering not an option for you? that is at instance level.
February 16, 2010 at 1:51 pm
rambilla4 (2/16/2010)
I'm using the stored procedure dtasp_RebuildIndexes provided by BizTalk and it's only rebuilds indexes for 10 tables inside the database BizTalkDTA.
For 'normal' SQL server database it is usually good...
February 16, 2010 at 10:44 am
only thing you need to make sure is you take TempDB log backups consistently so that log space will not grow and use all disk space.
GT You can't backup tempdb.
You...
February 16, 2010 at 8:32 am
rambilla4 (2/15/2010)
How big is the DB?
How much RAM does the server have?
How big are the indexes being rebuilt?
The database size is 7 GB
We have 16 GB RAM (But We have...
February 16, 2010 at 4:51 am
Viewing 15 posts - 121 through 135 (of 457 total)