Viewing 15 posts - 44,836 through 44,850 (of 49,552 total)
Take the indexes that DTA recommends for one table, find all the queries that affect the table. Run the queries one by one and note how they perform. Apply 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
August 26, 2008 at 9:15 am
Eranda (8/26/2008)
E drive is congested, but it has more than 10 GB space left.
The amount of stuff on the drive doesn't influence the speed of reading/writing data.
Coming...
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
August 26, 2008 at 8:53 am
szahran (8/26/2008)
hmm i got ur point ..thanks but i really have no time ..
In that case it's unlikely that anyone will be able to help you properly.
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
August 26, 2008 at 7:57 am
SQL's probably gone and interpertted that as the 6th day of the 25th month.
No need for separate parameters, just a couple small changes.
ALTER PROCEDURE dbo.usp_Stock_Receipts
...
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
August 26, 2008 at 7:20 am
What parameters are you using?
One problem with using the yyyy/mm/dd format is that it's ambiguous. If I write 2008/04/10 does that mean the 10th of April or the 4th of...
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
August 26, 2008 at 6:36 am
That's saying that there's high IO latency on the E drive. A large number of IOs that were issued hadn't completed 15 seconds later. SQL prefers IOs to take under...
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
August 26, 2008 at 6:26 am
SET STATISTICS IO ON
GO
SET STATISTICS TIME ON
GO
then tun the proc. That will give you IO and time breakdowns for each statement.
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
August 26, 2008 at 6:20 am
G Bryant McClellan (8/26/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
August 26, 2008 at 6:14 am
Ok, then try something like this:
ALTER PROCEDURE dbo.usp_Stock_Receipts
@receiptDate datetime,
@originatorName varchar(50)
AS
...
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
August 26, 2008 at 6:03 am
Eranda (8/26/2008)
Recently I noticed sql server log (in EM) reported lots of IOs taking longer than 15 seconds messages, does this also add up?
That just means you have an IO...
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
August 26, 2008 at 6:02 am
Take its suggestions as just that. Suggestions. It's less accurate even than the Database Tuning Advisor.
Missing indexes is populated by the query optimiser as it's optimising queries. It will note...
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
August 26, 2008 at 5:57 am
SMAZ (8/26/2008)
Well I am expecting result in following order:1.10%
2.00%
10.00%
12.00%
Which is exactly the order my query returns them in. Did you try it?
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
August 26, 2008 at 5:56 am
richard (8/26/2008)
How should I be passing a date to the SP?
Bear in mind that datetimes are just that. Dates and Times.
If a user passes 2008/08/18 to your procedure,...
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
August 26, 2008 at 5:50 am
Smalldatetimes have full day, month, year and time included in them. When you pass 2008 to the procedure, it gets interpreted as '2008-01-01 00:00', and so when you do 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
August 26, 2008 at 5:48 am
They are sorted, they're just sorted as strings which is what the column is by the point the order by is evaluated. Perhaps something like this:
Select CAST(CAST(BaseColumn*100 AS numeric(10,2)) AS...
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
August 26, 2008 at 5:30 am
Viewing 15 posts - 44,836 through 44,850 (of 49,552 total)