Browse by Tags

Workspace Memory / Query Memory Tuning – RESOURCE_SEMAPHORE / IO_COMPLETION / SLEEP_TASK Waits

SQL Server is configured to use a lot of memory, but my query is slow and not using all the memory available and it is spilling the sort or the hash match operation to tempdb, how can you tune the configuration and the query? Memory allocating queries request memory based on estimation (ideal memory...

Posted to sqlworkshops (Weblog) by sqlworkshops on Fri, Oct 14 2011
Must attend training day for anyone serious about SQL

I was in Denmark earlier this year speaking at Miracle Open World and I heard about a guy that had done a session the year before about the internals of PDF files. This year he was doing the one on MDF files. This was a must see, so I popped along. Mark S. Rasmussen is the guy in question. What he had...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jul 26 2011
There are some more places available on the SQLBits training days

We’ve moved a few things around which has freed up some places on the Performance Monitoring and the Optimising BI Training Days at SQLBits 8 . SQL Server Performance Monitoring and Troubleshooting with Klaus Aschenbrenner It's Monday, 10:30am. You are just receiving an email that informs you that...

Posted to SQLBits (Weblog) by MartinBell on Thu, Mar 17 2011
More CPU cores may not always lead to better performance – MAXDOP and query memory distribution in spotlight

More hardware normally delivers better performance, but there are exceptions where it can hinder performance. Understanding these exceptions and working around it is a major part of SQL Server performance tuning. When a memory allocating query executes in parallel, SQL Server distributes memory to each...

Posted to sqlworkshops (Weblog) by sqlworkshops on Wed, Feb 2 2011
Performance Tuning and Query Optimisation–SQLBits Training Day

I will be doing a training day at SQLbits in April on Performance Tuning and Query Optimisation. This is the outline for the day. Its going to be an intense day, I look forward to seeing you there. To register go to http://www. sqlbits .com/information/registration.aspx . Places are limited so make sure...

Posted to Simons SQL Blog (Weblog) by simonsabin on Sat, Jan 29 2011
June 22-24, 2010 in London City Level 400 SQL Server Performance Monitoring & Tuning Workshop

We are organizing the “3 Day Level 400 SQL Server Performance Monitoring & Tuning Workshop” for the 1st time in London City during June 22-24, 2010 . Agenda is located @ www.sqlworkshops.com/workshops & you can register @ www.sqlworkshops.com/ruk . Charges: £ 1800 ( 5% discount for those who...

Posted to sqlworkshops (Weblog) by sqlworkshops on Thu, May 13 2010
SQLBits Videos for SQLBits V

I am in the process of uploading all the SQLBits videos. They look great. All the videos should be up by the end of the week. As taster you can see my session here http://sqlbits.com/Agenda/event5/When_a_query_plan_goes_wrong/default.aspx to watch in a local media player use this link http://sqlbits...

Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Jan 25 2010
SQLBits Videos for SQLBits V

I am in the process of uploading all the SQLBits videos. They look great. All the videos should be up by the end of the week. As taster you can see my session here http://sqlbits.com/Agenda/event5/When_a_query_plan_goes_wrong/default.aspx to watch in a local media player use this link http://sqlbits...

Posted to SQLBits (Weblog) by simonsabin on Mon, Jan 25 2010
Session videos from SQLBits IV are now available

You can now view the videos from SQLBits A - Manchester We also have download versions as well http://sqlbits.com/information/event4/PublicSessions.aspx We hope you find them useful. If you are considering coming to SQLBits V then have a look at what you can expect. -

Posted to Simons SQL Blog (Weblog) by simonsabin on Sat, Aug 15 2009
Session videos from SQLBits IV are now available

You can now view the videos from SQLBits A - Manchester We also have download versions as well http://sqlbits.com/information/event4/PublicSessions.aspx We hope you find them useful. If you are considering coming to SQLBits V then have a look at what you can expect.

Posted to SQLBits (Weblog) by simonsabin on Sat, Aug 15 2009

Page 1 of 2 (15 items) 1 2 Next >