Viewing 15 posts - 20,521 through 20,535 (of 49,552 total)
If you have multiple queries and you want to see which is best, run them and time them, it's that simple. Use STATISTICS TIME.
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
February 7, 2012 at 1:51 am
I've seen that, was the IT security team running a test against my DB. Chat with your sysadmins, with your IT security people
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
February 7, 2012 at 1:50 am
Is that the same DB? What's happened between when you ran the first one and now? There are thousands of errors that have 'disappeared'
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
February 7, 2012 at 1:32 am
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
February 6, 2012 at 5:07 pm
At the moment the only predicate used to filter rows is the Vessel ID. All of the others are evaluated later when the rows are read.
First thing, fix the date...
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
February 6, 2012 at 3:55 pm
Not a picture of the plan please, a picture of the operators are near-useless. Save the plan as a .sqlplan file and attach it to your post.
Also, try changing 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
February 6, 2012 at 3:18 pm
This is a decent place to start:
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
February 6, 2012 at 2:50 pm
sqlfriends (2/6/2012)
Because it said to run the query, I guess it means in SQL server buffer that has not enough memory, am I wrong?
No, it does not mean that. It's...
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
February 6, 2012 at 2:45 pm
Just checking, Full text enabled? Full text queries been run?
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
February 6, 2012 at 2:37 pm
What's the partition function?
The first thing that strikes me is that your where clause is not SARGable and will require SQL to do an index scan. It may not 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
February 6, 2012 at 2:27 pm
Cool, let me know how it goes.
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
February 6, 2012 at 2:24 pm
There is one VLF active:
2 194904064 32744996864 ...
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
February 6, 2012 at 2:10 pm
That the master database has a single log file (only 1 file ID), that single log file has 6 VLFs (6 rows), the 3rd, 5th and 6th are active (they...
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
February 6, 2012 at 1:41 pm
sqlfriends (2/6/2012)
[The first thing that you need to do is set the max server memory to a sensible value that will ensure SQL does not try to starve the OS....
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
February 6, 2012 at 1:38 pm
What does the SQL errorlog say?
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
February 6, 2012 at 1:34 pm
Viewing 15 posts - 20,521 through 20,535 (of 49,552 total)