Viewing 15 posts - 46,561 through 46,575 (of 49,552 total)
Technical advice only here, cause I have no knowledge of USA laws.
Have you considered enabling C2 or Common Criteria logging? They'll both produce a lot of data but they will...
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
May 14, 2008 at 12:20 am
You could add the login to the sysadmin fixed server role. It gives the account full systed admin privilidges, but if you're OK with that...
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
May 14, 2008 at 12:11 am
gan (5/13/2008)
By the way, most of the sites is using MSSQL 2000, any idea?
Other than suggesting that SQL 2000 questions should go in the SQL 2000 forums?
Dunno. I'm still...
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
May 14, 2008 at 12:00 am
TheSQLGuru (5/13/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
May 13, 2008 at 11:52 pm
GSquared (5/13/2008)
The reason I mention federating is because it was mentioned that this used to be 7 tables on 7 servers, if I'm reading it correctly.
Missed that. Thanks
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
May 13, 2008 at 11:48 pm
The sp_adduser/sp_addrole are deprecated in SQL 2005
Rather use CREATE USER ... and CREATE ROLE ...
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
May 13, 2008 at 3:04 pm
I'll go with a simple partitioned table (partitioned on the day of week, or the day of month, depending on data volumes) Don't see any need to add the complexity...
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
May 13, 2008 at 2:58 pm
magarity kerns (5/13/2008)
GilaMonster (5/12/2008)
Also corporate policy states all servers will use SAN storage.
The solution suddenly came to me after I re-read this sentence: Get the "pedestal" version 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
May 13, 2008 at 2:31 pm
jamiejulius (5/13/2008)
The checkpoint process kicks in as a result of accumulated write activity, which needs to be flushed to the disk....
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
May 13, 2008 at 2:22 pm
Try running the query from a querying tool (query analyser). It's easier to see the SPID and removes any possibility of the slow down coming from somewhere other than SQL.
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
May 13, 2008 at 2:14 pm
I had anj idea it was the problem at the beginning, wasn't sure.
Jamie: The root problem is that your IO sustem is not adequate for the load you're putting on...
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
May 13, 2008 at 8:01 am
Could you please explain more what you're trying to do and what problems you're encountering.
You have a table with 2.1 billion rows in 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
May 13, 2008 at 7:58 am
I'm most interested in the wait type (it's hex), the last wait type and wait resource (if any)
If the CPU is increasing or static, if the reads are increasing or...
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
May 13, 2008 at 7:51 am
Checkpoints are internal operations. They won't show up in profiler
You can log the output of:
SELECT * from sys.dm_exec_requests where session_id < 50
Log it every few sec. You should see some...
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
May 13, 2008 at 5:54 am
Very odd. The optimiser has a limit on how much time it's allowed to spend considering a plan. It shouldn't be that long.
What do you see in sysprocesses for that...
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
May 13, 2008 at 5:50 am
Viewing 15 posts - 46,561 through 46,575 (of 49,552 total)