Viewing 15 posts - 1,036 through 1,050 (of 2,838 total)
GilaMonster (4/7/2012)
Stefan Krzywicki (4/7/2012)
Is there a way to access this information now or would I have had to be capturing it all along. All I have is historical run times.
You...
April 7, 2012 at 1:04 pm
GilaMonster (4/7/2012)
Single drive, no RAID, no redundancy?
As far as I know, yes. It is the impression I've gotten from meetings we've had about the system and our attempts to get...
April 7, 2012 at 1:01 pm
One other thing to note, we're running the backups on this machine through EMC software's SQL Server backup system. Yesterday and today it has been far slower than normal and...
April 7, 2012 at 12:59 pm
GilaMonster (4/7/2012)
Stefan Krzywicki (4/7/2012)
GilaMonster (4/7/2012)
April 7, 2012 at 12:54 pm
Perry Whittle (4/7/2012)
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...
April 7, 2012 at 12:52 pm
Perry Whittle (4/7/2012)
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...
April 7, 2012 at 12:44 pm
GilaMonster (4/7/2012)
April 7, 2012 at 12:43 pm
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 H
That's all...
April 7, 2012 at 12:08 pm
GilaMonster (4/7/2012)
Stefan Krzywicki (4/7/2012)
GilaMonster (4/7/2012)
Snapshot isolation?The warnings point to something slowing down the IOs on teh TempDB drive. Check that there hasn't been any changes to the Io subsystem recently
What...
April 7, 2012 at 11:47 am
Table Definition
[dbo].[FTD](
[TransDetailID] [int] NOT NULL,
[TransID] [uniqueidentifier] NOT NULL,
[ProdID] [int] NULL,
[FP] [int] NOT NULL,
[TransTypeID] [smallint] NULL,
[Units] [smallint] NULL,
[Price] [smallmoney] NULL,
[UnitOfMeasure] [varchar](10) SPARSE NULL,
[ComboSeq] [int] SPARSE NULL,
[ComboID] [int] SPARSE ...
April 7, 2012 at 11:37 am
GilaMonster (4/7/2012)
Snapshot isolation?The warnings point to something slowing down the IOs on teh TempDB drive. Check that there hasn't been any changes to the Io subsystem recently
What do you mean...
April 7, 2012 at 11:26 am
I'm suddenly unable to create an index on a table. The creation has been running nightly for over a year, but just stopped, it tries to run, but won't finish.
April 7, 2012 at 9:50 am
CHECKDB on tempdb showed no problems.
April 7, 2012 at 9:44 am
SQLRNNR (4/5/2012)
Steve Jones - SSC Editor (4/5/2012)
SQLRNNR (4/5/2012)
Topic Change:If you are in the area (or just visiting)
Check this out:
Congrats, and very cool.
And apparently...
April 5, 2012 at 1:53 pm
Thought I'd mention this here for anyone who's a fan of golden age comics.
Kickstarter Project: The Encyclopedia of Golden Age Superheroes by Jess Nevins
He's a world-class researcher and a good...
April 5, 2012 at 12:34 pm
Viewing 15 posts - 1,036 through 1,050 (of 2,838 total)