Viewing 15 posts - 46,336 through 46,350 (of 49,552 total)
Matt Miller (5/29/2008)
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
May 30, 2008 at 12:13 am
Best way to see if there's a performance difference - test and measure.
Boise (5/29/2008)
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
May 29, 2008 at 11:59 pm
Chirag (5/29/2008)
One more thing... supposing that this is live production database with a large amount of data what are the options available for this problem.
Pretty much the same. CheckDB can't...
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
May 29, 2008 at 11:56 pm
You have corruption in your database. It's corruption in the system tables, so CheckDB is not going to be able to repair.
I don't suppose you know when the corruption occurred...
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
May 29, 2008 at 5:32 am
Is the table perhaps in a different schema than dbo?
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
May 29, 2008 at 5:23 am
18456 is Login Failed. It's usually due to incorrect username or bad password.
Are you using windows authentication or sql authentication?
If windows authentication, are you local admin on the machine ?
Is...
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
May 29, 2008 at 5:23 am
tschoenig (5/29/2008)
Is there a way to switch the Primary-Index to a non-clustered index?
Not switch it. Drop the NC index, drop the primary key, create the clustered index, create the nonclustered...
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
May 29, 2008 at 1:08 am
If you're just doing a single insert, there's no need for an explicit transaction. All statements run within a transaction that starts when th statement starts and autocommits if 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
May 29, 2008 at 1:04 am
It's the repeating groups I'm talking about
[LagSpeedGlueUnit1] [int] NULL,
[LagSpeedGlueUnit2] [int] NULL,
[LagSpeedGlueUnit3] [int] NULL,
...
[SteamTemperatureSection1] [int] NULL,
[SteamTemperatureSection2] [int] NULL,
[SteamTemperatureSection3] [int] NULL,
[SteamTemperatureSection4] [int] NULL,
Repeating groups should be split out into separate tables (1NF)....
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
May 29, 2008 at 12:55 am
Then I revise my suggestion - normalise your table.
You've got a very unnormalised design which will make it hard if not impossible to create covering indexes.
Alternative suggestion (that may be...
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
May 29, 2008 at 12:38 am
You certainly should not be truncating the trasdaction log on a regular basis. If you don't care about been able to restore to a point in time, set the recovery...
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
May 29, 2008 at 12:33 am
Could you show us what LogUserActivity does?
Does the the app that uses this DB use Connection Pooling?
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
May 29, 2008 at 12:30 am
The reason you've got as difference is because of the number of rows.
The 2 day query is returning 42k rows and that number is (probably just) small enough that SQL...
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
May 29, 2008 at 12:23 am
What comes to mind is using xp_readerrorlog to get the log, then looking for the line that reads
Logging SQL Server messages in file 'D:\Somewhere\ERRORLOG'.
It seems to be there whether 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
May 28, 2008 at 6:58 am
Take a test server, take baseline readings of the CPU usage, IO usage, etc. Implement some traces, take new readings.
If you're running SQL 2005, you already have a serverside trace...
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
May 28, 2008 at 6:28 am
Viewing 15 posts - 46,336 through 46,350 (of 49,552 total)