Viewing 15 posts - 1 through 15 (of 43 total)
Great ! Thank you.
January 24, 2014 at 9:16 am
Yes, data will be divided, but IO activity will also hit all the drives. My attempt is to optimize application performance by spreading out the IO activity.
July 19, 2013 at 3:56 pm
Thank you for the Paul Randall blog - it will be helpful.
I tested a new SAN by running SQLIO every hour from a VM server for several months, and looked...
July 19, 2013 at 12:26 pm
Lowell,
This was a big help - thank you. I changed the SQL Server service account to be the key application's account, and logged in with that account. ...
May 28, 2013 at 12:27 pm
The service account that is running the MSSQLSQLServer is in the "Administrators" group, SQL Server management Studio is "Run as Administrator", and the service account has "db_owner". There is...
May 21, 2013 at 11:21 am
I did - the one message is above.
October 29, 2012 at 9:33 am
I don't fully understand your question, but if you are trying to determine the speed of your IO subsystem I suggest the free Microsoft tool SQLIO - search for "SQLIO...
November 16, 2010 at 1:10 pm
I was looking at Windows Task Manager (Windows Server 2003) columns Mem Usage and Peak Mem Usage. Maybe they just don't show more then 4GB.
I will stick to using...
August 13, 2010 at 11:21 am
From the DMV:
object:
SQLServer:Memory Manager
counter_name: Target Server Memory (KB) ...
August 13, 2010 at 9:31 am
After posting this question I changed the server memory.
min server memory (MB)1638416384
max server memory (MB)2048020480
awe enabled00
Version info:
Microsoft SQL Server 2005 - 9.00.4053.00 (X64) May 26 2009 14:13:01 ...
August 13, 2010 at 8:38 am
After posting I changed the server memory max and min to 16384 and 20480 respectively; it had been the default zero to 2 petabytes. AWE is not enabled -...
August 13, 2010 at 8:20 am
The job failed. Unable to determine if the owner (domain\user) of job NAME has server access (reason: Could not obtain information about Windows NT group/user error code 0x54b....
July 7, 2010 at 8:25 am
UPDATE - this is still a problem. I'm surprised that I seem to be the only one suffering this.
I have 5 SQL Server Integration Services (SSIS) packages that...
March 9, 2010 at 8:06 am
The query is generated by SSIS OLE DB data source provider - I do not know how to change it.
January 28, 2010 at 6:25 am
The ORACLE query is generated by the SSIS OLE DB Data Source when I try to get the list of tables. Does anyone know how to control, to edit,...
January 26, 2010 at 10:29 am
Viewing 15 posts - 1 through 15 (of 43 total)