Gail Shaw

Forum Replies Created

Viewing 15 posts - 35,626 through 35,640 (of 49,552 total)

RE: Need Technical Details for this TSQL

Never mind the bold one, the other three are an extremely bad idea. Shrinking the log just means it'll grow again, slowing things down as it does. Truncating the log...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 7:35 am

#1084596
RE: Sleeping/Awaiting Command

sqllearner-339367 (11/26/2009)
Can you give me some direction how to carry out further analysis.
Sure, those two articles that i posted the links to are just that.
As for the long running one,...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 7:29 am

#1084593
RE: DBCC DROPCLEANBUFFERS

DropCleanBuffers drops everything from one of SQL's memory areas - the data cache. If you just run that you leave the procedure cache intact, the system caches intact, few other...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 4:41 am

#1084542
RE: SQL Memory Issues

The max memory controls the buffer pool. There's always a little memory more that SQL uses - thread stacks, backup buffers, CLR, some other stuff. It's not usually big. If...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 4:36 am

#1084540
RE: I'm sure the solution is simple - so I MUST be really STOOOPID or just 'SQL blind'

For a good introduction to triggers in SQL, please read this: http://www.sqlservercentral.com/articles/Triggers/64214/
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 4:24 am

#1084537
RE: SQL Memory Issues

craighenderson (11/25/2009)
My SQL Server 2005 has 38Gb allocated to it and its currently using 42Gb, problem is it never frees up any of this memory for other processes and 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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 4:23 am

#1084536
RE: Sleeping/Awaiting Command

You need to investigate where the slow down is. Why are you returning thousands of rows to query analyser anyway? Who's reading those thousands of rows?
For an intro to performance...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 4:20 am

#1084535
RE: How to Move tables from one FileGroup to another in SQL 2000

npbalan (3/3/2009)
We r using sql server 2000 .I want to move all the user table from PRIMARY fileGroup to another FileGrop.
Why? What are you trying to achieve?
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 4:16 am

#1084533
RE: DBCC DROPCLEANBUFFERS

craighenderson (11/26/2009)
This is what I was worried about, I currently have 25Gb in my buffer pool for my live DB and I was wondering if clearing this would make my...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 4:15 am

#1084531
RE: DBCC DROPCLEANBUFFERS

Andrew Gothard-467944 (11/26/2009)
What it does is clear down your procedure cache - if you run against live you're going to see your box hammered until your most commonly used queries...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 4:13 am

#1084529
RE: DBCC DROPCLEANBUFFERS

Do not run this against a production server without a really good reason. You say you want to run it. Why?
What this does is go through the data cache 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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 4:12 am

#1084527
RE: Sleeping/Awaiting Command

sqllearner-339367 (11/26/2009)
I have found that this particular table (73 columns) takes long time to retrieve more than 1000 rows. It does quickly retrieve top 10 and top 100 in no...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 2:52 am

#1084498
RE: Sleeping/Awaiting Command

sqllearner-339367 (11/25/2009)
There are lot of process in our server were the status is sleeping and cmd is Awaiting Command.
Sleeping just means connected but not currently running any commands. It...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 2:50 am

#1084496
RE: Query getting High Executions - Index scan

winslet (11/26/2009)
i applied indexing but still its a costly query.
Indexing won't help in the slightest when you're querying all columns and all rows.
The users who don't need all 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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 26, 2009 at 2:48 am

#1084495
RE: Query getting High Executions - Index scan

Well, the query's asking for all the columns and all the rows in the table, so there's no real way to optimise. You're asking for the entire table, so 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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

November 25, 2009 at 11:02 pm

#1084453

Viewing 15 posts - 35,626 through 35,640 (of 49,552 total)