Viewing 15 posts - 47,071 through 47,085 (of 49,552 total)
IMHO, update usage isn't worth running often. The CheckDB is done by the integrity check as well as this piece of home-brewed code.
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
March 27, 2008 at 2:33 pm
Dunno about missing checkpoint, but if there's an open transaction then the log records can't be discarded until the transaction has completed.
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
March 27, 2008 at 2:20 pm
Can you post the SQL queries, the table structure and any indexes on those tables? Also, if you have the deadlock graph that will be very useful (Obtain deadlock graph...
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
March 27, 2008 at 2:17 pm
I can answer that when you tell me how much memory's on the server.
What version of SQL 2005? (What does SELECT @@version return?)
To give you an idea, one of my...
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
March 27, 2008 at 2:16 pm
Those IO stats don't look too bad. 99.6% of all reads are done from memory not from disk. There's virtually no swapping occurring. Not really what I would expect if...
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
March 27, 2008 at 2:03 pm
ben.ashton (3/27/2008)
If We run the following in Query Analyser:SELECT SERIALNO, TITLE, FIRSTNAME, SURNAME FROM
CONTACT WHERE SURNAME LIKE 'A%'
If you run that in Query analyser with the execution plan enabled, what...
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
March 27, 2008 at 1:47 pm
Ashwin M N (3/27/2008)
I checked each of the queries they are not what we call bad queries. They cannot be optimized further which I am sure.
Can you post one...
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
March 27, 2008 at 1:39 pm
SQL Noob (3/27/2008)
Michael Earl (3/27/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
March 27, 2008 at 1:33 pm
How much memory do you have? What service pack of SQL are you running? 32 bit or 64 bit?
If you run the following, what's taking the most memory?
select [Name], SUM(single_pages_kb...
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
March 27, 2008 at 1:30 pm
The one thing I noticed is the date comparisons. You should rather do comparisons (with between if necessary) of the dates as datetimes rather than converting the dates to strings...
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
March 27, 2008 at 1:24 pm
Nothing I posted was SQL 2005 specific.
For the counters, use performance monitor. They're not within profiler.
Check the server's max and min memory settings. Check to see if AWE 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
March 27, 2008 at 8:14 am
As a first suggestion, run profiler and capture the T-SQL Batchcompleted and StoredProc:RPC completed events. Run it for an hour or so during one of your busy periods. You can...
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
March 27, 2008 at 7:50 am
Faessler Gilles (3/27/2008)
Currently on the server there is only a full backup of all dbs once a day. No log backups at all. IfI unterstand it right the logs continues...
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
March 27, 2008 at 4:02 am
Snapshot isolation probably will fix the deadlocks, but you do need to check and make sure it will not break any code. You also have to take the impact 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
March 27, 2008 at 1:23 am
IN doesn't parse apart a comma-delimited string. The form with a subquery is equivalent to an inner join
Your query
select * from employee where employee_typ in (select [value] from cfg_elements...
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
March 27, 2008 at 1:07 am
Viewing 15 posts - 47,071 through 47,085 (of 49,552 total)