Everyone who works with workflow designer (and if you are TFS Build Developer – you do it a lot ) encounter the problem with Workflow Designer slowness and crashes (happened to me like 20 times today ) . Today, Microsoft announce a patch for that ! This patch includes fixes to ASP.Net & Silverlight as well and other 35 issues and 6 features as you can find in KB 2468871 . Read more in Buck Hodges post . Grab it from Here .   Happy Building.

The following post cover a few tips and tricks that can improve you iSCSI performance. Before making this changes in a production environment, its recommended to: 1. Contact the storage and the server vendor support team and check with them the suggested recommendation in this post. 2. Test the effect of the suggested changes in a testing environment that is the same as the production environment. Note: Ignoring the aboved recommendation can lead to a data corruption.   General 1. Use the latest...

It is still not late to register and take part in the talk. This talk is going to be one of the richest sources of information about AppFabric Caching available, so you will definitely benefit from it. For details and registration: https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032460308&Culture=he-IL Here is the abstract for the talk: A vast majority of web applications use some kind of relational database to keep data. As it turns out, databases, while being robust, are the source...

Administrative Report Pack for Team Foundation Server 2010 Couple of days ago Grant Holliday's post about new Reports pack for TFS admins to answer the following question: How long is cube processing taking? How much time elapses between processing jobs? How often do the processing jobs run? Do errors occur with when the cube is processed? Process Times: Current Processing Status This table tells you whether the warehouse is currently being processed or when it will be processed next. The Next...

This is continued live blogging from the Donald Farmer seminar from the SQL & BI convention in Tel Aviv of Data Integration in Large Organizations. SSIS 2008 Performance and Scalability The importance of measuring to improve performance Understand and measure hardware: How many CPU cores? How much memory? How fast is the I\O subsystem? Understand the potential bottlenecks: Understand the limits of the Source System (usually a bottleneck as it's usually slower than the new system) Gains from...

On a previous post I wrote about how the number of databases in an SSAS instance can make an impact on the overall performance of the instance. In this post I want to discuss another, more “explainable” property that you can set in order to improve cube processing performance. Trying to optimize processing time of our databases I set up a performance monitor trace to identify if we are having any resource bottlenecks that we need to address. Looking at the “Physical Disk: Disk Writes Bytes/sec” counter...

I’ve been researching a few performance issues lately on an Analysis Services 2005 instance with 20 (almost) identical databases on it, each weighing roughly 2.5GB and containing 6-7 cubes with approximately 400 partitions in each cube. As you can imagine, this makes up quite an impressive number of files stored on disk. SSAS stores everything on files, and unlike its relational relative (no pun intended), which will store hundreds of GB of data on a fairly small number of large files (I know this...

I recently was required to check on the performance of an SSAS instance. We had a new OLAP model with several MDX queries that we wanted to ensure were performing adequately. Now, you may know that SSAS is using caching in order to speed up its response time. Initial queries are directed to disk and once data is first read, it is then being placed in cache to serve future queries faster, eliminating the need to access disk again. What we did first was to clear the cache, using the following XMLA...

Not too many people know that they can query internal performance and resource related data for SSAS using DMVs. Yes, I’m talking about similar DMVs to the much more known relational database DMVs, only these DMVs can be queried by connecting to an SSAS instance, open a new MDX or DMX query window (either way will work for you) and type a simple SELECT statement which retrieves the information from the DMVs. These DMVs are actually metadata that is kept internally as schema rowsets and you can simply...

Hi guys, It was very nice meeting you all yesterday at the re-birth of the Infrastructure & Management User Group. Below is the presentation for the main subject we talked about – “Windows 2008 R2 Overview”. We will continue next month, on December 17th with the subject “Active Directory improvements in Windows 2008 R2”. In the meantime, share your thoughts and interesting finds at the group site - http ://www.linkedin.com/groupRegistration?gid=2389097 Have a great weekend and take care! :) What's...