Viewing 15 posts - 1 through 15 (of 17 total)
Also, if you are looking for a more detailed and long term activity monitor, it is something you can actually setup yourself. Microsoft provided us with SQL traces and the...
Jason
Webmaster at SQL Optimizations School
September 16, 2011 at 11:43 am
Hi,
Creating SQL traces and importing the data into a table is the based way to track performance over time. This is all the monitoring software does and you can create...
Jason
Webmaster at SQL Optimizations School
September 14, 2011 at 4:49 pm
Hi,
We like to setup SQL trace files to run all the time and dump the results into a table. This allows us to do a couple things:
1. Have an easy...
Jason
Webmaster at SQL Optimizations School
September 3, 2011 at 1:05 pm
I find the following script to be very helpful when making changes to a database I am unfamiliar with. Let's say you have a table or procedure that needs to...
Jason
Webmaster at SQL Optimizations School
August 4, 2011 at 4:33 pm
On a lot of our servers, we like to keep performance traces running throughout the year. This allows us to look at a few reports to check on long running...
Jason
Webmaster at SQL Optimizations School
July 26, 2011 at 8:34 am
If you are looking for optimization techniques and steps, you can visit the site in my signature. Something you might want to try with those empty tables is to load...
Jason
Webmaster at SQL Optimizations School
July 26, 2011 at 8:29 am
You can visit this site and it will take you through a lot of the introductory steps. There is also a troubleshooting tool that can help to identify some of...
Jason
Webmaster at SQL Optimizations School
July 26, 2011 at 8:24 am
You can try stopping and closing the trace. Then try again. I am not sure what your whole trace setup looks like, but you need to add events, columns, filters,...
Jason
Webmaster at SQL Optimizations School
July 20, 2011 at 3:37 pm
This tool can help you get started with figuring out the basics:
Performance Troubleshooting Tool
Jason
Webmaster at SQL Optimizations School
July 19, 2011 at 4:03 pm
Hi,
We had some comments on the page I posted above in relation to cursor speed and whatnot. In the end, I went to the Microsoft SQL updates/service packs and tried...
Jason
Webmaster at SQL Optimizations School
July 11, 2011 at 10:43 am
Try to do what you can to minimize the data volume as well. Ask yourself these kinds of questions:
- How long you need to keep the data for? Purge Old...
Jason
Webmaster at SQL Optimizations School
July 9, 2011 at 8:12 pm
Were these the type of results that you were needing?
SELECT *
FROM Table_Name
WHERE Code IN (
SELECT Code
FROM Table_Name
GROUP BY Code
HAVING COUNT(*) >= 2
)
Jason
Webmaster at SQL Optimizations School
July 7, 2011 at 9:31 pm
Isn't the MAXDOP option reliant on the number of processors that the server has? Does your test server have only 1 processor?
Jason
Webmaster at SQL Optimizations School
July 6, 2011 at 4:13 pm
If you do find yourself stuck in a situation where you need to cycle through every record in a table, here is a good example of how to code a...
Jason
Webmaster at SQL Optimizations School
July 5, 2011 at 9:05 pm
The site in my signature also has some good material for learning the basics of optimizations.
Jason
Webmaster at SQL Optimizations School
July 5, 2011 at 8:54 pm
Viewing 15 posts - 1 through 15 (of 17 total)