Viewing 15 posts - 5,761 through 5,775 (of 9,241 total)
Welsh Corgi (4/7/2012)
I could not eve log on so I removed SQL Server 2008 R2.
Why didn't you just put it single user mode and add the appropriate account into sysadmins?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 1:46 pm
Run this and let me know what happens
CREATE NONCLUSTERED INDEX NoddyIDX ON dbo.FTD
(ProdID ASC)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 1:26 pm
Before going any further I would like you to confirm exactly the configuration of the logical disks, also is this server a virtual machine by any chance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 1:03 pm
Stefan Krzywicki (4/7/2012)
I'm sorry, I don't know how to answer that question.You mean other than each of those being a different physical drive?
Yes, exactly. Get your server admin to confirm...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 12:49 pm
Stefan Krzywicki (4/7/2012)
Well, I had been running the index creation with WITH SORT_IN_TEMPDB = ON, so wouldn't the sort space be happening on C?
Yes it would hit C drive
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 12:46 pm
Stefan Krzywicki (4/7/2012)
Perry Whittle (4/7/2012)
Other things to considerHow many logical drives are you using?
What are the physical disk configs underneath these?
System dbs on C
log files on G
data files on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 12:42 pm
Other things to consider
How many logical drives are you using?
What are the physical disk configs underneath these?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 12:03 pm
Jeff Moden (4/7/2012)
check the scheduled jobs and see what's happening around that time frame.
Great minds think alike 🙂 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 11:37 am
Can you supply the table definition too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 11:33 am
The backup related tables you require are in the MSDB. Use the following query
Select database_name, Compatibility_level, Recovery_model,
DATABASEPROPERTYEX(database_name,'Status'), Type
from msdb.dbo.backupset
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 11:28 am
Are referring to native or 3rd party backups, there is a difference
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 7:57 am
kranthi.india123 (4/7/2012)
3.6. Update statisticsIt is recommended that, after having committed or changed the compatibility mode to 100, execute the stored procedure: sp_updatestats
You first execute DBCC UPDATEUSAGE(), this is required when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 6:55 am
As an extra option you could turn SORT_IN_TEMPDB on, this may offload somewhat to the TempDB rather than using the database filegroup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 6:46 am
shahgols (4/6/2012)
Given the setup below, what would happen if the tempdb on the C:\ drive fills up? Will SQL Server crash or does it continue processing by using...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 4:36 am
Server side traces have much less impact apart the potential for required disk space depending on what you are monitoring
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 4:33 am
Viewing 15 posts - 5,761 through 5,775 (of 9,241 total)