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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 7, 2012 at 12:59 pm
GilaMonster (4/7/2012)
Stefan Krzywicki (4/7/2012)
GilaMonster (4/7/2012)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 7, 2012 at 12:44 pm
GilaMonster (4/7/2012)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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 ...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 7, 2012 at 9:50 am
CHECKDB on tempdb showed no problems.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 5, 2012 at 12:34 pm
Viewing 15 posts - 1,036 through 1,050 (of 2,838 total)