Viewing 15 posts - 46,141 through 46,155 (of 49,552 total)
I wouldn't suggest putting the log on the OS drive. If you do that it's compeating with the swap file. Bad idea.
Can you buy a 3rd drive?
Where's TempDB?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 5:45 am
Ok, let's see if I have this straight.
You have 3 disks in a raid 5 config. The one resultant raid array is then divided into 3 partitions, c:, d: and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 5:37 am
pduplessis (6/20/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 3:08 am
pduplessis (6/20/2008)
Sometimes you are restricted by some things that you really take for granted.
I've learnt never to take anything for granted.
Obviously in some countries like mine, the level of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 2:35 am
mithun gite (6/20/2008)
should i need to put switch of 3gb to increase the memory?
Your memory is not the issue. Your drives are the issue right now. First thing is to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 2:33 am
pduplessis (6/20/2008)
Interestingly enough, they still aint backing up, no matter how much squeeze my boss is putting on them.~PD
Um..... <speechless>
They are planning on implementing backups once it becomes production. Right?
Restoring...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 1:59 am
cgchavero (6/19/2008)
I need to copy some databases from SQL 2000 to SQL 2005 and set Compatibility Level to SQL 2005 automatically.Tanks!
Why not just restore a backup? It'sll probably be faster...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 1:45 am
sram24_mca (6/20/2008)
SELECT@ServiceID = I.ServiceID, @Name = I.[Name],@LocationID = I.LocationID, @ModifiedBy = I.CreatedBy,
@Deleted = I.Deleted
FROM INSERTED I
One problem with your trigger straight off, ignoring performance problems...
It only caters for single...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 1:20 am
TheSQLGuru (6/19/2008)
This mechanism does opens up the possibility of a dictionary attack to retrieve the value.
Suggestion I've seen to avoid that is to have a salt in a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 1:13 am
Could you post an example of one of those triggers please? It's hard to talk about increasing performance without some code.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 1:05 am
OK. wanna check something first. Those values are for the sec/read, not the read/sec?
If so, You have major IO problems! The memory doesn't look bad, the cache hit ratio is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 12:45 am
Are you sure that the sleeping sessions come from IIS?
Are these sessions blocking other sessions? Why are you concerned about them?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 12:42 am
Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic520315-338-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 12:30 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic520331-148-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 12:28 am
The remote server or the driver for the linked server doesn't allow remote transactions.
It's nothing to do with the proc rewrite. Check the linked server settings or check with the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 12:24 am
Viewing 15 posts - 46,141 through 46,155 (of 49,552 total)