SqlServer-QA.net

The above error was returned on a SQL Server 32 bit system that is used for an inventory application, the initial though on out of memory was to see what is the resource usage at that moment as the SQL Server memory settings are set to DYNAMIC and all necessary AWE settings are enabled. As you may be aware that a 32-bit SQL Server, ...

SQL Server 2008 is on full-fledge now and I haven't had a chance to look at Analysis Services part of it, recently had an opportunity to go through to convene a proof of concept project at work place. As the documentation refers this version of Analysis Services, special emphasis was taken to improve the performance in the execution of MDX ...

PERFMON and Resource Governor - two great tools in hand for a DBA to monitor/resolve the performance problems, agreee! Back in olden days you may remember about SQLDiag and PSSDiag, the utility used as a general purpose diagnostics collection utility that can be run as a console application or as a service. Both of these Diag tools are helpful to ...

In continuation to SQL Server - Precision Performance techniques using RML Utilities and SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose? posts here it will be a wonderful news for DBAs to hear that Microsoft Development team developed an update for the RML Utilities which now ...

Few months ago I had an excellent opportunity to learn and share the knowledge within SQL Server performance tuning, Tech-Ed Online talks [remember Tech-ed Online Panel: Leveraging ... ]. Same in the series Amit Bansal, SQL Server MVP from India and myself had a brief chalk-talk online session on query tuning techniques and also brief tips ...

It is no doubt that when a database consists 'well-designed' indexes  can reduce disk I/O operations and consume fewer system resources therefore improving query performance. You might be wondering I'm going back to basics for indexes! So when the database consists filtered indexes, they are very handy to optimize the ...

What will be the main challenge for a DBA/User to manage a large Data Warehouse (DW) environment, size does matter and also think about downtime you need to deploy whenever any patches are required. Before that you need to be perfect or well-versed with Data partitioning & Data lifecycle within that DW environment.  Also buidling up ...

How many tools do you (need/use0 to monitor the performance of your SQL Server instance(s)? Well, I'm not asking any count on the x number of tools you require to monitor the SQL Server instances within your environment, and Performance Tuning using Management Studio unlike any other tool to figure out to monitor the performance tuning. ...

How many tools (new and enhanced) are available within SQL Server 2008 when you have a need to monitor the performance of queries that are executing/generated? The initial ones you remember is PROFILER and PERFMON (SYSMON) tools, even further few will say Performance Dashboard reports & Dynamic Management Views. The new tools that are ...

If you work in Financial based Enterprise then Sarbanes-Oxley is not a new concept for you as per American law that regulates the accountability of publicly owned companies. Just to talk about the main purpose of the law it to make sure the financial statement that a company reports is legitimate and that there’s no room for someone to manipulate ...