-
as seen on Server Fault
- Search for 'Server Fault'
I have a problem with sqlservr.exe (version 2008). It use a more memory. I checked on windows taskbar manager, sqlservr.exe usage ( Mem usage - 8GB Ram). I dont know how can I fix it.Got the following metrics of the server using Perfmon:
SQLServer:Buffer Manager
Buffer cache hit ratio
13
SQLServer:Buffer…
>>> More
-
as seen on Super User
- Search for 'Super User'
I have a windows 7,32 bit laptop. I am the administrator with all permissions.
when I click on the SQL server 2008R2 set up file,it says :
"SQL server set up has encountered the following error:Failed to retreive data for this request" click on OK.
I have uninstalled all the components of SQL from…
>>> More
-
as seen on Simple Talk
- Search for 'Simple Talk'
In my previous post, I introduced the SQL Monitor data repository, and described how the monitored objects are stored in a hierarchy in the data schema, in a series of tables with a _Keys suffix. In this post I had planned to describe how the actual data for the monitored objects is stored in corresponding…
>>> More
-
as seen on SQLIS
- Search for 'SQLIS'
If you are building SSIS 2008 packages programmatically and adding data flow components, you will probably need to know the creation name of the component to add. I can never find a handy reference when I need one, hence this rather mundane post. See also CreationName for SSS 2005. We start with…
>>> More
-
as seen on SQL Authority
- Search for 'SQL Authority'
The job of an SQL Consultant is very interesting as always. The month before, I was busy doing query optimization and performance tuning projects for our clients, and this month, I am busy delivering my performance in Microsoft SQL Server 2005/2008 Query Optimization and & Performance Tuning Course…
>>> More
