Viewing 15 posts - 29,251 through 29,265 (of 49,552 total)
Nope.
If you don't know what the problems are, do a full checkDB. Two reasons
1) If you post here asking for help, it's the first thing I'll ask you to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 10:56 am
Which version did you try running that script on?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 10:50 am
Chris Morris-439714 (11/22/2010)
"Jack Corbet is in hospital, they suspect he has had a heart attack, he seems ok as he was on twitter last...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 10:44 am
Unless you have a specific form of contention, spitting into 8 files on the same drive may not give you much if any performance gains. Are you seeing contention on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 10:37 am
Why 8 files?
What's the max size your TempDB has ever reached?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 8:37 am
What version of SQL are you running?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 8:33 am
Why write your own when there are so many good and well-tested scripts around. http://www.sqlfool.com for starters.
My guess, those are really small indexes (<24 pages)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 8:32 am
MSDN is wrong (for 2000 as well as 2005).
If the index has no fragmentation and the file it is in has no fragmentation then it may be that the logical...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 6:14 am
The questions are taken at semi-random from a pool of questions. The exact number and breakdown will differ for each candidate. Check the list of skills covered over at the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 6:11 am
Excellent. One thing left to do.
GilaMonster (11/19/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 6:07 am
If you have SQL 2005, why are you posting in the SQL 2000 forums? People are going to assume you are running SQL 2000 and give you an answer appropriate...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 3:34 am
There's nothing built-in that stores that.
Why would a monitoring job not be approved? Surely management wants the servers monitored?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 2:45 am
Create a SQL Agent job, schedule it every 30 min. If you don't have permission to create it, ask your DBA.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 1:19 am
What version of SQL Server?
What are the settings for the following (select from sys.configurations)
AWE Enabled
Max server memory
What operating system?
What's the output from SELECT @@Version?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 1:07 am
dhaval.joshi.dj (11/21/2010)
and as a database I am using DB2.
This is a Microsoft SQL Server forum, not a DB2 forum. We're all familiar with SQL Server here. If you have a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 21, 2010 at 11:12 pm
Viewing 15 posts - 29,251 through 29,265 (of 49,552 total)