Viewing 15 posts - 31 through 45 (of 151 total)
To get the memory SQL uses, tun the following...
SELECT
--Amount of physical memory on server
physical_memory_in_bytes
, physical_memory_in_bytes / 1024 / 1024.00 as physical_memory_in_MB
,virtual_memory_in_bytes
, virtual_memory_in_bytes / 1024 / 1024.00...
May 16, 2011 at 11:00 am
SQLMyFriend (5/12/2011)
I talked with our network guy, it's not possible for them to add another memory disk on that computer.
A network guy is managing the SQL Server????
OK, let me ask...
May 13, 2011 at 10:48 am
"I found that the Windows Cluster group is offline, and the IP address is showing as failed because its already in use."
Somebody stole your MS Clusters's virtual IP address.
Go get...
May 12, 2011 at 1:59 pm
For kicks, grant "sa" as the job owner and see if it keeps happening.
😀
May 12, 2011 at 10:49 am
"The file name "\\pulse\Image_Storage\ToProcess\" specified in the connection was not valid."
It looks like it's looking for a file name but it's given a Directory path.
"IGIVE Connection manager "IGCXML" Description: The...
May 12, 2011 at 10:03 am
I said 8GB because it sounded like you didn't want to have less than 4GB for the OS. Anything more than 8GB for SQL is better.
A box with 12GB is...
May 12, 2011 at 8:56 am
Have you checked the hard drive performance during this slowness? What's the Disk Queue lenght metrics show?
Also, If I were you I wold set the start memory for SQL at...
May 11, 2011 at 5:06 pm
jordonpilling (5/11/2011)
Problem is, this procs call about 15 other procs (got to love 3rd party software).
Aw man.....
Nested SP's, you have my sympathy.
Try scheduling the agent job to run 20...
May 11, 2011 at 2:48 pm
OK, I figured it out. I had to disjoin the domain first because it is now in the LAB. Kind of weird :hehe: considering I changed ALL the SQL services...
May 11, 2011 at 2:44 pm
Are you using an SSIS package? If you are, you need to put logic in there to replace NULL with CHAR(32) before you insert it into your SQL table.
I think...
May 11, 2011 at 2:36 pm
Try changing the column to a varchar() and assign a default value. If I recall correctly, nvarchar() requires the data to be padded. So if you have an nvarchar(10), you...
May 11, 2011 at 12:34 pm
Set each cell in the SQL table a "Default Value" that is either an empty space or "N/A" or "<UnKnown>" or etc...?
May 10, 2011 at 5:09 pm
Yes.
Here's why I say it does.
The linked server uses one set of credentials provided by the Oracle DBA.
When creating the linked server in SQL 2005 those are the credentials...
January 28, 2011 at 11:34 am
I thought about that but as I am told by the "Network Guru's", nothing like that is happening.
I think I will move the time closer to business times just...
January 28, 2011 at 11:26 am
Viewing 15 posts - 31 through 45 (of 151 total)