Viewing 15 posts - 19,036 through 19,050 (of 49,552 total)
Ratheesh.K.Nair (4/17/2012)
I saw only one page and went through that.
Err, no, that's a full book of 350 pages. What you quoted was the blurb. Read chapters 1 and 4.
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
April 17, 2012 at 6:57 am
Scale-out can be done with peer-to-peer replication, but it has to be designed carefully and it's not a trivial thing to set up.
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
April 17, 2012 at 5:47 am
Sure it's possible. Read up on Database Mail
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
April 17, 2012 at 5:15 am
Did you read the two chapters I indicated?
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
April 17, 2012 at 5:05 am
How are you checking memory usage?
SQL uses as much memory as it needs. If it's using 3GB memory, it needs 3GB memory or more to do the work it's doing....
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
April 17, 2012 at 4:30 am
REpair_rebuild should work, however the DB has to be in single user mode for the duration of the repair. That'll be at least as long as a normal checkDB, possibly...
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
April 17, 2012 at 4:29 am
Chapter 1, chapter 4: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
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
April 17, 2012 at 4:25 am
I assume you mean you want to increase application timeout, not query execution time.
It'll be changed in the application (because SQL has no concept of a timeout). In .net 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
April 17, 2012 at 4:22 am
aykut canturk (4/17/2012)
so, as I understand the only solution is use column base encryption to hide data from eyes and change application level codes.
If you mean SQL-based column encryption, that's...
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
April 17, 2012 at 4:19 am
Make sure that the tech checks everything, drives, cache, controllers, etc. I doubt this is the actual physical disk that's the problem, but culd weasily be something else in 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
April 16, 2012 at 3:32 pm
Do so, and see if the read cache can be disabled for testing.
Is it possible to shut that SQL Server down and stress-test the IO subsysten?
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
April 16, 2012 at 2:45 pm
Little to none. The only risk is for primary key or unique constraints where you may have an index hint referencing the constraint by name. Other than that, change at...
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
April 16, 2012 at 2:10 pm
hbtkp (4/16/2012)
but this is how i am getting my final data in report.
so based on how they calculate , i need to do implement...
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
April 16, 2012 at 2:07 pm
It has been suggested to me that the problem may lie in the SAN caches. Can you get the SAN admin to check that there are no errors (dropped pages...
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
April 16, 2012 at 2:05 pm
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
April 16, 2012 at 12:17 pm
Viewing 15 posts - 19,036 through 19,050 (of 49,552 total)